Massimo,
Monday, August 19, 2002, 10:40:50 AM, you wrote:
MP> As in your instruction on 4 jul 2002 23:51:13 I added the
MP> SET NO_FOREIGN_KEY_CHECKS=1;
^^^
Should be:
SET FOREIGN_KEY_CHECKS = 0
MP> after having installed 3.23.52 for WIN on my win2k syst
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 12:52 PM
Subject: Re: new command in 3.23.52 - innodb database schema dump
> Massimo,
>
> it was c
> As in your instruction on 4 jul 2002 23:51:13 I added the
>
> SET NO_FOREIGN_KEY_CHECKS=1;
>
> after having installed 3.23.52 for WIN on my win2k system in the first
line
> of my shema dump (obtained with MYSQLDUMP -opt);
>
> But wheh I lanch the command
> mysql database
> I received the fol
As in your instruction on 4 jul 2002 23:51:13 I added the
SET NO_FOREIGN_KEY_CHECKS=1;
after having installed 3.23.52 for WIN on my win2k system in the first line
of my shema dump (obtained with MYSQLDUMP -opt);
But wheh I lanch the command
mysql database http://www.mysql.com/manual.php (th
10:06 PM
Subject: innodb database schema dump
> I had the same problem, and while I don't think there's a way around it,
you
> can load the schema with the force option so that it will eventually make
it
> to the table the must be created first, (even if a previous table creation
>
I had the same problem, and while I don't think there's a way around it, you
can load the schema with the force option so that it will eventually make it
to the table the must be created first, (even if a previous table creation
gives an error). Running the script many times over and over will
ev
how can i dump innodb tables schema with foreign key references
so that the tables are created in the right order ?
thanks,
Pierre
--
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
