MySQL Forums
Forum List  »  Replication

How to resync a master-slave server
Posted by: Flavio Tobias
Date: January 22, 2012 10:03PM

Hi I have two servers one master and another slave. The slave had a crash and because of that the databases has become unsynchronized.
When I try to start the slave with "START SLAVE" I got a lot of problems, I tried to solve them one by one manualy but every time I fix one another pops up.

My last alternative is to make a hard copy of data folder of master on slave, but in order to do that I need to stop the mysql for about 3 hours, and I cannot do that.

Is there any way to resync these databases without shuting down the master database?


Options: ReplyQuote

Written By
How to resync a master-slave server
January 22, 2012 10:03PM

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.