RE: mysqldump table order with foreign keys

2003-12-19 Thread Paul DuBois
- 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 trying to dump the structure of a database using: mysqldump -d myDatabase > structure.sql Which works fine in getting t

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&#

mysqldump table order with foreign keys

2003-12-19 Thread sean peters
Hey all, I'm trying to dump the structure of a database using: mysqldump -d myDatabase > structure.sql Which works fine in getting the table create statements, but, how do i get mysqldump to put the creates in an order that will allow replication with foreign key concerns. For instance if i