[ale] Database Delta's ?

Greg Freemyer greg.freemyer at gmail.com
Tue Aug 28 10:50:52 EDT 2007


All,

I do a nightly mysql dump or a relatively small DB that typically gets
only a few edits per day.  I keep an archive of those dumps going back
90 days.

This morning we had a question about what edits were made yesterday,
so I naively thought I could just do a diff between the last 2 dumps
and see what changes occurred.

Turns out the dump has one huge line of data per table, not one per
row.  So the diff basically was huge and uninformative.

I can change my dump/backup process but I would like to have the
ability to determine what edits where made in a given day.

Does anyone have any pre-existing tools for this?

Or do I need to script up something that will dump each row separately
so a diff will work?

FYI: The db is not used at night, so I don't have to worry about
quiescing it during the backup script.

-- 
Greg Freemyer
Litigation Triage Solutions Specialist
http://www.linkedin.com/in/gregfreemyer

The Norcross Group
The Intersection of Evidence & Technology
http://www.norcrossgroup.com



More information about the Ale mailing list