Re: mysqldump and DBs with FKs

2002-07-24 Thread Victoria Reznichenko
Sergio, Wednesday, July 24, 2002, 6:15:57 AM, you wrote: SB> Im getting in trouble trying to restore a .sql dump generated with SB> mysqldump for a database with lots of foreign keys because of the SB> order of tables in the .sql. the first table already declares a SB> FOREIGN KEY referencing a t

mysqldump and DBs with FKs

2002-07-23 Thread Sergio Bruder
Im getting in trouble trying to restore a .sql dump generated with mysqldump for a database with lots of foreign keys because of the order of tables in the .sql. the first table already declares a FOREIGN KEY referencing a table not yet created, halting with a 'cant create blahblahblah'. (ERROR 1