Interesting idea. So if I take the table from Sept 10th and then do that with the binlog I'll be missing about 2 months worth of data because my earliest binlog file is Nov 12th.
The queries are always one to a line in the binlog? Best Reguards, Jeff > -----Original Message----- > From: Dathan Pattishall [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 18, 2005 2:16 PM > To: Jeff McKeon; mysql@lists.mysql.com > Subject: RE: Restoring a database from binlogs > > > 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]
