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 = 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 = 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 = 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 <mysql-unsubscribe-##L=##[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php