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_
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
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,
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>
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
... 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
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
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
__