Re: Restoring a db with RI enforced

2004-04-29 Thread Victoria Reznichenko
"Lou Olsten" <[EMAIL PROTECTED]> wrote: > If I'm using mysqldump to dump a database with referential integrity in place, does > MySQL > build the information in such a way that the referenced tables are loaded first to > avoid > invalid inserts into a table with a foreign key in place? I'm tryin

Restoring a db with RI enforced

2004-04-28 Thread Lou Olsten
If I'm using mysqldump to dump a database with referential integrity in place, does MySQL build the information in such a way that the referenced tables are loaded first to avoid invalid inserts into a table with a foreign key in place? I'm trying to find an option for mysqldump, and the closes