i tried it ... but nothing to do! when mysql parse the foreign key in the create table i get the error.
perhaps i'm wronging in restoring tables/db! i use this method: shell> mysql -u <user> -p<password> < <dump file> is it wrong? thanks. Natale Babbo --- Victoria Reznichenko <[EMAIL PROTECTED]> ha scritto: > Natale, > Friday, October 25, 2002, 10:08:00 AM, you wrote: > > NB> ok ... that's right for data (insert into ...) > ... but > NB> i get the error before ... when mysql try to > create > NB> child table: > NB> CREATE TABLE ... idParent BIGINT, INDEX > idpar_ind > NB> (idParent), FOREIGN KEY (idParent) REFERENCES > NB> parent(id) > NB> .. when mysql parses the foreign key, parent > table > NB> doesn't exist yet! > > No, it's true not only for data. > Put > > SET FOREIGN_KEY_CHECKS=0; > > in the dump file and then restore tables. It works > fine for me. > > NB> --- Victoria Reznichenko > NB> <[EMAIL PROTECTED]> ha scritto: > > NB> 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