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.
--
Scott
Iphone says hello.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to