MySQL Forums
Forum List  »  Replication

Re: How to start replication over from scratch....
Posted by: Rick James
Date: March 16, 2014 09:08PM

Starting over requires one or the other of these:

* Having the binlog turned on even before doing the first CREATE DATABASE, and still having ALL the binlogs on the Master. Action:
1. DROP DATABASE for all databases other than `mysql`, `information_schema`, `performance_schema`.
2. CHANGE MASTER ... -- point to the first binlog with POS=0.

If you did not turn on binlogging soon enough, or you don't still have all the binlogs, then you need to look at the other option:

* Copy all the data from the Master to Slave, turn on binlogs, CHANGE MASTER to the point where you copied all the data.
If you pick this solution, we can go into more detail.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to start replication over from scratch....
1009
March 16, 2014 09:08PM


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.