----- 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 <file.dump > > > > 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