Are there any scripts that help with data recovery?


(Daniel) #1

I have a customer who lost three days of data. Here is the situation: The last datadump was done on 1/08 but there was a system failure on 1/13 that caused all data from the 8th to the 13th to be lost. On the 12th there was a snapshot taken of the server but it was unavailable until the 20th. I was able to get the data that was entered in the system from 1/8 thru 1/13, but the live system is missing that data.

I’m wondering if there is a script that can help me import the data. I did a diff between the last instance of the snapshot 1/8 and the snapshot before everything faile on the 1/13 and I see there are about 20 tables whose number of rows changed (some of these are custom tables).

If a script doesn’t exist, I can write one.


(Stephen Waite) #2

I’ll cc @jesdynf since he may know of some nice tools


(Asher Densmore-Lynn) #3

Alas, I’ve got nothing directly helpful. https://stackoverflow.com/questions/225772/compare-two-mysql-databases may be of use.


(Daniel) #4

I’ve been working on a script. I’ll post once I’m done. I found a better solution.