Dump the binarylogs into a text file greping all the log data in order of oldest to newest (minus the massive delete). Then reply the events backinto mysql
Mysqlbinlog <binlogs in order> |grep [your tablename] > BIGSQLFILE.sql mysql -uroot <database> < BIGSQLFILE.sql DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Jeff McKeon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 18, 2005 11:31 AM > To: mysql@lists.mysql.com > Subject: Restoring a database from binlogs > > Hey all, > > I've got a big problem. Seems one of our programmers decided > to write a script that deletes all records from a log table > older than 3 months. > Problem is, we need old data from this log to reconcile our > customer accounts. > > Our backups only go back 2 weeks. What I do have however is > replication running and therefore old binlogs. These binlogs > go back as far as Nov 12, 2004. The "cleaning" of the log > table didn't start until about a month ago and has deleted > any data prior to Jan 18, 2005. > > The only snapshot I can find of the database is from Sept 10, 2004. > > So.. (shooting off into the dark) I have binlogs starting > from Nov 12, a snapshot from sept 10th. Is there some way > anyone can suggest that I can reconstruct the database table > with what I have? > > Best Reguards, > > Jeff > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
