Jungsu, Jeremy, it can be considered as a bug that MySQL/InnoDB does not replicate the setting
SET FOREIGN_KEY_CHECKS=0 I am working on fixing this bug in 4.0.x. Regards, Heikki Innobase Oy sql query ----- Original Message ----- From: ""Jeremy Tinley"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, February 21, 2003 6:01 PM Subject: RE: "SET FOREIGN_KEY_CHECKS = 0" Suggestion. > Changing one local variable, IMO, shouldn't replicate. > > I would much rather have a REPLICATE command that I could place before = > any SQL > command that causes it to replicate. This keeps local variables local, = > but in > the event I need to replicate a change to all my slaves without going to = > each > one, I can. > > -J > > -----Original Message----- > From: wertyu [mailto:[EMAIL PROTECTED] > Sent: Friday, February 21, 2003 3:15 AM > To: [EMAIL PROTECTED] > Subject: "SET FOREIGN_KEY_CHECKS =3D 0" Suggestion. > > Hello, everyone. > > I'm using MySQL replication(Version 4.0.10) > > Master and slave have FOREIGN KEY constration. > and I back up data with mysqldump. > but mysqldump does not produce table and record invalid order for FK. > > So,when I restore data, I execute "SET FOREIGN_KEY_CHECKS =3D 0;" on = > master. > > But, this command does not forwarded to Slave. > so, slave fails to insert record. > > So my suggestion is "SET FOREIGN_KEY_CHECKS =3D 0;" forwarded to slave. > > What do you think of this? > > Have a nice weekend! > > ########################## > Heo, Jungsu Mr. > SimpleX Internet. http://www.simplexi.com > > Filter : sql > > > > --------------------------------------------------------------------- > 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/doc/ (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/doc/ (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