See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
mysql SET FOREIGN_KEY_CHECKS = 0;
mysql SOURCE dump_file_name;
mysql SET FOREIGN_KEY_CHECKS = 1;
Bob
-Original Message-
From: Robert A. Rosenberg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 5:56 PM
To:
At 18:01 -0400 on 06/01/2004, Bartis, Robert M (Bob) wrote about Re:
Reloading Database with Foreign Keys:
See http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
mysql SET FOREIGN_KEY_CHECKS = 0;
mysql SOURCE dump_file_name;
mysql SET FOREIGN_KEY_CHECKS = 1;
Bob
Thanks