"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]
