Jeff McKeon wrote:
Jeff,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
The data between the snap shot and when the logging started is gone. Since you do have the binlogs, extract them to text files and write a perl script to figure out what insert/update statements you need. I've done it before and it took some time to make sure I grabbed the correct update/insert statements. As a side note, it might be worth the $$$ to setup a replication server that you can take off-line to do cold backups. When you make the backups, you know exactly what time and what logfile and posistion it was at. The replication server in most cases doesn't need near the processing power the primary db does. Good luck !
walt
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
