MySQL Forums :: Replication :: reset slave


Advanced Search

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

Hi,

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 master.info 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

Cecile

Options: ReplyQuote


Subject Views Written By Posted
reset slave 7690 cecile rangheard 07/08/2005 09:18AM
Re: reset slave 3550 hector fragoso 07/11/2005 09:38AM
Re: reset slave 3496 Tereza Zambrano 07/15/2005 11:04AM
Re: reset slave 2907 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.