List:Replication« Previous MessageNext Message »
From:Nitin Mehta Date:May 12 2012 3:47am
Subject:Replication and foreign key constraints
View as plain text  
I'm facing a problem with MySQL replication. I want to replicate a set of tables from
master to this server where some processing needs to be done. These tables are from
multiple schemas. I thought I'd set "foreign_key_checks = 0" and this should take care of
the problem. However, this only worked for database import but replication is still
failing with "Error 1451: foreign key error".
Is this a known issue or any solution to this will be highly appreciated.