Restoring Database: Error 1064

Enrique · Post #1 (**permalink**) 10-27-2005, 08:53 AM

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 · Post #2 (**permalink**) 10-27-2005, 09:27 AM

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

Enrique · Post #3 (**permalink**) 10-27-2005, 10:57 AM

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

Thank you!

Exon · Post #4 (**permalink**) 10-27-2005, 11:02 AM

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

Joomla · Post #5 (**permalink**) 12-19-2005, 11:43 PM

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 · Post #6 (**permalink**) 04-25-2006, 02:09 PM

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

--compatible=40