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
