MySQL Forums :: Replication :: Relay-Bin Log file is missing. How to skip?


Advanced Search

Re: Relay-Bin Log file is missing. How to skip?
Posted by: James Day ()
Date: April 22, 2006 01:27PM

You lose data if you skip. There are two solutions:

1. CHANGE MASTER TO the positon _on the master_ where the slave was, the slave will get the transactions from the master binary logs again and you will lose nothing. Requires that the master still has those binary logs.

2. Recopy everything to the slave as a new slave setup.

James Day
Support Engineer, MySQL AB

Options: ReplyQuote


Subject Views Written By Posted
Relay-Bin Log file is missing. How to skip? 26318 Michael Wheat 03/21/2006 11:26AM
Re: Relay-Bin Log file is missing. How to skip? 13693 Michael Wheat 03/21/2006 11:27AM
Re: Relay-Bin Log file is missing. How to skip? 14641 James Day 04/22/2006 01:27PM
Re: Relay-Bin Log file is missing. How to skip? 15188 Scott Paterson 11/25/2007 03:54PM
Re: Relay-Bin Log file is missing. How to skip? 13484 KimSeong Loh 11/25/2007 04:33PM
Re: Relay-Bin Log file is missing. How to skip? 11484 Scott Paterson 11/25/2007 04:54PM
Re: Relay-Bin Log file is missing. How to skip? 7297 Manny Garcia 10/03/2008 05:49PM


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.