A client deleted their database and did not have a slave in place for
backup. No scheduled dumps either.
However, I have set up a slave to the master for one table. These
tables hold DNS data for database driven DNS server features.
The master table is empty, the slave rightly saw the deletes and
carried them out.
But I believe the replication logs on the slave, and also perhaps on
the master should still be there. I'm not clear on how large these
get, if they roll/truncate, etc.
Is there any way to restore the master up to the point the data was
deleted? I can then set the slave to resync and they should be back
where the left off.
There are a lot if records, not a lot of data since DNS data is so
small. If I could restore the master It would prove quite helpful.
Currently, all servers are down since DNS is not working, as a result
of DNS being backed by MySql via DLZ/named.
Thanks for any suggestions.
Iphone says hello.