From: Nitin Mehta
Date: May 12 2012 3:47am
Subject: Replication and foreign key constraints
List-Archive: http://lists.mysql.com/replication/2355
Message-Id: <1336794469.12348.YahooMailNeo@web161602.mail.bf1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="406169123-863483307-1336794469=:12348"

--406169123-863483307-1336794469=:12348
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,=0A=A0=0AI'm facing a problem with MySQL replication. I want to replicat=
e=A0a 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 "fore=
ign_key_checks =3D 0" and this should take care of the problem. However, th=
is only worked for database import but replication is still failing with "E=
rror 1451: foreign key error".=0A=A0=0AIs this a known issue or any solutio=
n to this will be highly appreciated.=0A=A0=0ARegards,=0ANitin
--406169123-863483307-1336794469=:12348--