MySQL Compat

Published on Nov. 15, 2006

I've run into this error quite a few times, might as well toss blog entry about it:

ERROR 1064 at line 17: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 7

One likely reason this comes about is because the data being imported/exported is not compatible with the database version. For instance, at home you export the information from a mysql5 database. Then you try to import it on a mysql3.23 database somewhere else -- and it craps out on you. Bummer.

The solution is quite simple:

 mysqldump --compatible=mysql323 -u root -p database > exportName.sql

Tagged as: databases | mysql
blog comments powered by Disqus