Results 1 to 1 of 1
Jun 9, 2003, 12:04 #1
moving databases from one server to another, error appeared
I was trying to move all my database from my Ensim box to this new CPanel box. I used the dump command below on the ensim box :
mysqldump -u root -p --all-databases > alldump.sql
however when I tried to restore :
mysql -u root -p < alldump.sql
Ive gotten the below error :
ERROR 1064 at line 47112: 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 -manual_com at line 1
the old ensim box mysql version is 3.23.56 while the new cpanel is 4.0.12. one of the domain is my-domain.com and it seems the new version doesnt like "-" in between. Whats is the correct command to use?
thanks in advance!