Single Patient Restore

voipbound wrote on Saturday, October 29, 2011:

A patient was accidentally deleted from our system.  I have a backup from a dump.  Can someone help me to retrieve that one patient from my last backup?

TIA

jason0 wrote on Tuesday, November 01, 2011:

Hello,

In your log, there will be an entry for each database line deleted from mysql.  you should be able to get all of the deleted data out of the log comments, and re-construct insert statements from them.

While you can restore from a backup, this will allow you to restore exactly what you deleted.

-jason