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
