• View
• Edit
• History
• Print

MySQL

Stuff you wanted to know about MySQL

Turn off foriegn key checks

From the MySQL manual:
FOREIGN_KEY_CHECKS = {0 | 1}

If set to 1 (the default), foreign key constraints for InnoDB? tables are checked. If set to 0, they are ignored. Disabling foreign key checking can be useful for reloading InnoDB? tables in an order different from that required by their parent/child relationships.

So if you do a mysqldump, put this at the top of the file before reloading to avoid FK constraint errors.