MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Foreign Key errors on slave after import from another slave
Posted by: Rick James
Date: May 13, 2013 08:27PM

What you did seems reasonable. But here is another way...

Stop mysqld on the slave; copy (rsync / scp / ...) the entire mysql directory tree to the new slave; start both slaves. (No CHANGE MASTER is needed.)

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.