2

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?

Improve this question
2
  • Are you loading the dump manually on both systems? Or is the slave pulling the dump via replication and failing to replicate the binary log? Commented Mar 8, 2011 at 17:13
  • I loaded it on to just the master and the slave pulled it over via replication. The error was presented on the slave with show slave status. Commented Mar 8, 2011 at 18:31

1 Answer 1

Reset to default
4

Usually when you do a mysql load of a dump, you disable foreign key checks, then re-enable them, in fact it might do this by default. You simply need to do the same thing on the slave for the duration of the replication.

This is an import export guide:
http://technocation.org/files/doc/2010_06_BulkLoad.pdf

Disabling foreign keys:
http://gauravsohoni.wordpress.com/2009/03/09/mysql-disable-foreign-key-checks-or-constraints/

Improve this answer
1
  • Thank Ben. Didn't think of manually disabling the checks on the slave. Commented Mar 16, 2011 at 13:04

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.