RE: mysqldump table order with foreign keys

2003-12-19 Thread Paul DuBois
At 11:16 -0600 12/19/03, Victor Pendleton wrote: You will need to place the following at the head of your dump file. SET FOREIGN_KEY_CHECKS=0 Also, in MySQL 4.1, mysqldump does this automatically. It puts out the following at the beginning of the dump file: /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQU

RE: mysqldump table order with foreign keys

2003-12-19 Thread Victor Pendleton
You will need to place the following at the head of your dump file. SET FOREIGN_KEY_CHECKS=0 -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:28 AM To: [EMAIL PROTECTED] Subject: mysqldump table order with foreign keys Hey all, I'm tryi