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
-
> 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
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 |grep [your tablename] > BIGSQLFILE.sql
mysql -uroot < BIGSQLFILE.sql
DVP
Dathan Vance Pattishall http://www.friend
