MySQL Forums :: Replication :: reset slave

Advanced Search

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

Subject Views Written By Posted
reset slave 7793 cecile rangheard 07/08/2005 09:18AM
Re: reset slave 3606 hector fragoso 07/11/2005 09:38AM
Re: reset slave 3541 Tereza Zambrano 07/15/2005 11:04AM
Re: reset slave 2947 Domas Mituzas 07/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.