Restoring Database: Error 1064

[Enrique]

Old server MySQL version: 4.1.13-standard
New server MySQL version 4.0.25-standard

I am moving my site to a new server and when I try to restore the database on the new server I get the following error:

Error 1064 at line 21: 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 'DEFAULT CHARSET=latin1' at line 6

Any help/advice would be greatly appreciated.

 

[Exon]

Jose,
Is there any way of updating the MySQL on the new server so we could rule that out as a possibility?

 

[Enrique]

John, that's exactly what I did. Problem solved. :beer:

Thank you!

 

[Exon]

YAY! Don't ya love it when things work?

 

[Joomla]

This error can be solved by making sure you backup your database 'with backquotes'.

Newer versions of mysql can 'choke' on fields that are not enclosed with backquotes.

 

[littleswebhost]

WHen dumping the data database, put in the compability tag, the goes something like:

--compatible=40