ok ... that's right for data (insert into ...) ... but i get the error before ... when mysql try to create child table: CREATE TABLE ... idParent BIGINT, INDEX idpar_ind (idParent), FOREIGN KEY (idParent) REFERENCES parent(id) .. when mysql parses the foreign key, parent table doesn't exist yet!
bye and thanks. Natale Babbo --- Victoria Reznichenko <[EMAIL PROTECTED]> ha scritto: > 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 > ______________________________________________________________________ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.yahoo.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