Can you automatically create a mysqldump file that doesn’t enforce foreign key constraints?
The mysqldump command included with MySQL since version 4.1.1 by default produces a script that turns off the foreign key checks. The following line is included near the top of the dump file: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; The /*!40014 … */ syntax is a conditional comment that will be executed on MySQL version 4.0.14 … Read more