mysqldump and Foreign Keys

[Michael Satterwhite]

mysqldump backs all of the tables up in alphabetic order, including the 
table create statements. The problem is that if foreign keys exist on 
the tables, the reload will not work unless the backup file is hand 
edited to insure that tables depended upon are created first. Is there a 
way around this? If not, shouldn't the tables be created first and the 
foreign keys created at the end of the backup? I *REALLY don't want to 
hack mysqldump and am hoping that there's already a way around this - or 
that a way is being developed.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]