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>