banner
Jun 5, 2008
8 Views

Making mysqldump compatible with older versions

Written by
banner

If you receive some errors such as the following when trying to import your mysql database dump you are most likely attempting to dump a database from a newer version of MySQL and import it into an older version:

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′

OR

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=utf-8′

Solution?
Add the following parameter to your msyqldump statement:


–compatible=mysql40

Article Tags:
· ·
Article Categories:
Database
banner

Leave a Reply

Your email address will not be published. Required fields are marked *