Scott, Based on earlier messages, there's no way to just restore the master again. But can the data be recovered from the files? If it's InnoDB, then perhaps. See http://code.google.com/p/innodb-tools/. If it's MyISAM, one of our guys has made some partial work on a set of tools to serve a similar function -- extract the data from the files.
Either way, it's going to be tedious and/or mildly costly without guaranteed success. Baron On Wed, Jul 8, 2009 at 12:49 PM, Scott Haneda<talkli...@newgeo.com> wrote: > 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=ba...@xaprb.com > > -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
