I have a MySQL master-slave setup. One master; One slave; Lots of databases.
I'm moving an app into this setup from third party. They provided a mysqldump file of the data and database structure. It contains a single database with innodb tables.
The dump file loads just fine on the master. But while is replicating to the slave, the slave gets hung up on a foreign key error.
It seems like the slave is ignoring the 'set foreign key checks' in the mysqldump.
How do I load this thing without breaking replication?