Re: new command in 3.23.52 - innodb database schema dump
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 system in the first line MP> of my shema dump (obtained with MYSQLDUMP -opt); MP> But wheh I lanch the command MP> mysql database I received the following error: MP> ERROR 1064 at line 1: You have an error in your SQL syntax near MP> 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 -- 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
Re: new command in 3.23.52 - innodb database schema dump
- 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 changed to > > SET FOREIGN_KEY_CHECKS = 0; > > Please look at section 16 in the InnoDB Reference Manual. > > Regards, > > Heikki > > - Original Message - > From: "Massimo Petrini" <[EMAIL PROTECTED]> > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; ">" <[EMAIL PROTECTED]> > Sent: Monday, August 19, 2002 10:40 AM > Subject: new command in 3.23.52 - innodb database schema dump > > > > 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 following error: > > ERROR 1064 at line 1: You have an error in your SQL syntax near > > 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 > > > > > > Which is my error ? > > > > Regards > > > > Massimo Petrini > > sql query - 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
new command in 3.23.52 - innodb database schema dump
> 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 following error: > ERROR 1064 at line 1: You have an error in your SQL syntax near > 'NO_FOREIGN_KEY_CHECKS=1' at line 1line 1 > > > Which is my error ? > > Regards > > Massimo Petrini > - 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
new command in 3.23.52 - innodb database schema dump
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 (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
Re: innodb database schema dump
Hi! In upcoming 3.23.52 you can put SET NO_FOREIGN_KEY_CHECKS=1; at the start of your dump file. Then you can import your tables in any order. This syntax is not yet in 4.0.2. 4.0.2 will be released probably next week, 3.23.52 a few days later. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: "Christopher Book" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, July 04, 2002 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 > gives an error). Running the script many times over and over will > eventually add all the tables :). > Chris > > >>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 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 > - 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
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 gives an error). Running the script many times over and over will eventually add all the tables :). Chris >>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 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
innodb database schema dump
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 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