MySQL Database Error When Importing

  • Hi,

    I am trying to restore a backup of a WordPress site using the MySQL database. I have unzipped the files in the directory, created a new database and user with all privileges and modified wp-config file with the new database information. Then I go to import the mysql database from the backup in PHPMyadmin but get the following error message:

    #1044 – Access denied for user ‘mycpanelusername’@’localhost’ to database ‘olddatabase_name’

    After reading through these forums I then tried to modify the database before importing. I changed the database name to the new one, but then I get a different error message:

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘phpMyAdmin SQL Dump
    — version 4.0.5
    — https://www.phpmyadmin.net
    —
    — Host: lo’ at line 1

    I don’t get what I am doing wrong? I’ve done imports from backups before with different websites, but have never had this problem before? If anyone knows what the problem is I would really appreciate the help?
    Thanks!

Viewing 1 replies (of 1 total)
  • Thread Starter angelx3

    (@angelx3)

    Forgot to mention that this is a move from my old hosting (which has now gone and deleted) to another hosting (hostgator). I don’t know if this makes any difference?

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL Database Error When Importing’ is closed to new replies.