Re: Restoring a db with RI enforced

[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 trying to find an 
 option
 for mysqldump, and the closest one I see is --disable-keys, but I'm not sure if 
 that's
 what I need or not.

You can turn off foreign key checks with SET FOREIGN_KEY_CHECKS = 0 command.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





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

Restoring a db with RI enforced

[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 closest one I see is --disable-keys, but I'm not sure 
if that's what I need or not.

Thanks,

Lou