Hi,

I was trying to change the name of the database in my local computer to the same one in my public domain using phpmyadmin, but I got some error messages and after that I lost many tables in it. Fortunately, I have several back ups of my public database. I created a new database and then used source command to recover my website, but in my surprise at some point it gave me error 1064. I googled it and it said that:You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as "when" or "order".

I have created that backup file from my public domain database using cpanel, which i guess uses mysqldump, but I don't know why I cannot recover it on my computer.

Any idea how to do it?

Hi there,

Do you have command line access to the server ? This can help if you do...

Find your .sql backup file (I'm also assuming that cpanel used mysqldump and that you have a .sql file) and then you simply have to run this:

mysql < dbname.sql

You can also do this remotely provided you have access to the server where your backup is from your new one:

mysql -p -h DBSERVER dbname < dbname.sql

Cheers,

Unfortunately, I don't have access to terminal, since my server is a shared one.

Can you read the dump file? It may be trying to create a database/table that already exists or it may not be using the database when it tries to create the tables. If you look at the first few lines of the dump file, it will probably tell you what it is trying to do. If you can't figure it out from that, post the first 20 lines or so of your dump file.

HTH

Forrest

Actually it creates 5 tables. I guess inside the 6th table there are some weired characters that don't let me perform my query. The table is very big, that s why it s very hard to identify where the problem is coming from.

Well, if it creates 5 tables, then the problem is probably in the 5th table or the CREATE portion of the 6th table. Look at the 6th table's create and see if it doesn't have any strange problems, then look at the insert statements from the 5th table. You can run "select count(*) from table_5;" to see how many lines got inserted in that table to give you a place to start looking.

HTH

Forrest