As mysql replication sometimes breaks and it is not possible do recover the replication with the binary logs I would like to know if there is a possibility to dump certain tables or maybe a whole database to the binary log.
Is this possible?
Asked
Active
Viewed 28 times
0
-
1No, not in moment. you must dump the master and import it into the Slave. Why you cant restart the replication. What is the error ? – Bernd Buffen Dec 15 '16 at 10:51
-
Can you describe how replication breaks? Because there are many settings you can change to make it running better. – JosMac Dec 15 '16 at 10:53
-
First of all, thank you for your answers. It broke while i was on holiday because of a technical defect on the slave. My collegue said he repaired it, but something must have gone wrong. So i needet to do the offical way, because the binlogs are only stored 10 days (I increased this value) – c l Dec 15 '16 at 11:56