James Rodenkirch Web - Technology - Life

MySQL Dump Compatibility

At my current job I am constantly dumping mysql databases from a v5 server to import into a v3 server. In order for this to work, I have to dump the database in a mode that is compatible with version 3. Here is a quick reference for the compatibility modes available for mysqldump.

• ansi
• mysql323
• mysql40
• postgresql
• oracle
• mssql
• db2
• maxdb
• no_key_options
• no_table_options
• no_field_options

So, for my purposes I can execute the following command:

mysqldump my_database --compatible=mysql323 > sql.dmp