Are there any scripts that help with data recovery?

OpenEMR Development
#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.

#2

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

#3

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

#4

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