MySQL Forums
Forum List  »  Replication

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
Re: Relay-Bin Log file is missing. How to skip?
15131
April 22, 2006 01:27PM


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.