[ale] Database Delta's ?

[mike at trausch.us (Michael B. Trausch)]

Greg Freemyer, on 08/28/2007 10:50 AM said:
> 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.
> 

Pass --skip-extended-insert or --extended-insert=0 to mysqldump.

You will get one INSERT per database row, then.

	-- Mike

-- 
Michael B. Trausch               Internet Mail & Jabber: mike at trausch.us
Phone:  (404) 592-5746 x1                         http://www.trausch.us/
Mobile: (678) 522-7934             VoIP: 6453 at sip.trausch.us, 861384 at fwd
Pidgin 2.1.1 and plugins for Ubuntu Feisty! http://www.trausch.us/pidgin

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 252 bytes
Desc: OpenPGP digital signature