MySQL Forums
Forum List  »  Replication

reset slave
Posted by: cecile rangheard
Date: July 08, 2005 09:18AM


I have a very basic replication system running in Mysql 4.0.21. with one master and one slave.

After having some network problems, we reset the slave by error.
We stopped the slave, then launch "reset slave", then restart slave.

After these commands, we have the following error : "duplicate entry ..." because the slave tries (I think) to take some records that he already got.

Do somebody know a way to cancel the command "reset slave" to be able to restart the replication at the point it stopped.
Do you know a way to recover the and bin-log files ?

If it is not possible, do somebody know how to get a replication running without blocking the server ?

Do I have to use "load data from master" ?

Thanks in advance for your answers


Options: ReplyQuote

Written By
reset slave
July 08, 2005 09:18AM
July 11, 2005 09:38AM
July 15, 2005 11:04AM
July 22, 2005 02:32PM

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.