MySQL Forums
Forum List  »  Replication

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
7811
July 08, 2005 09:18AM
3609
July 11, 2005 09:38AM
3547
July 15, 2005 11:04AM
2954
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.