re: re: innodb tables backup

2002-10-25 Thread Paul DuBois
At 12:44 +0200 10/25/02, Natale Babbo wrote: 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 -p < is it wrong? Depends. - DId you add the SET FOREIGN_KEY_

re: re: re: innodb tables backup

2002-10-25 Thread Victoria Reznichenko
Natale, Friday, October 25, 2002, 1:44:19 PM, you wrote: NB> i tried it ... but nothing to do! NB> when mysql parse the foreign key in the create table i NB> get the error. NB> perhaps i'm wronging in restoring tables/db! NB> i use this method: shell> mysql -u -p < NB> is it wrong? What vers

re: re: innodb tables backup

2002-10-25 Thread Natale Babbo
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 -p < is it wrong? thanks. Natale Babbo --- Victoria Reznichenko <[EMAIL PROTECTED]> ha scritto: > Natale,

re: re: innodb tables backup

2002-10-25 Thread Victoria Reznichenko
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>

re: innodb tables backup

2002-10-25 Thread Natale Babbo
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! b

Re: InnoDB Tables Backup

2002-10-24 Thread Michael T. Babcock
... can someone add InnoDB to the list of keywords?? SQL ... QUERY ... Victoria Reznichenko wrote: 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 Out of curiousity, are the foreign key constraints check

re: innodb tables backup

2002-10-24 Thread Victoria Reznichenko
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

innodb tables backup

2002-10-24 Thread Natale Babbo
Anyone knows how to backup innodb tables in the right sql order? ... i mean ... to allow restoring correctly without foreign key constraint violation (if in the backup file ddl code for the child table is before ddl code for the parent table i get an error). Thanks in advance. Natale Babbo __