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 =
>
ne, 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 FOR
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,