Natale, Thursday, October 24, 2002, 10:57:00 AM, you wrote: NB> Anyone knows how to backup innodb tables in the right NB> sql order? NB> ... i mean ... to allow restoring correctly NB> without foreign key constraint violation (if in the NB> backup file ddl code for the child table is before ddl NB> code for the parent table i get an error).
You can set up SET FOREIGN_KEY_CHECKS=0, in this case foreign key constraints will not be checked. It's supported since 3.23.52 and 4.0.3 -- 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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
