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!