Re: Restoring a database from binlogs

2005-05-18 Thread kernel
Jeff McKeon wrote: 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 h

RE: Restoring a database from binlogs

2005-05-18 Thread Jeff McKeon
- > 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

RE: Restoring a database from binlogs

2005-05-18 Thread Dathan 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

Restoring a database from binlogs

2005-05-18 Thread Jeff McKeon
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 rep