Hacker News Reader

I usually add a commit hook to run 'mysqldump'. Then you get a matching database snapshot along with the source code.

TIP: For better diff's use "--skip-extended-insert --skip-dump-date".

A nice gui on top of that is welcome (although I'm not sure about the $30K).

Why mysqldump instead of using the binary log? Just dump the result of SHOW MASTER STATUS to a text file in your git directory, back up your binary log files on a regular basis, and then you just use the stop position feature of the binlog utility[1] to restore to that point in time from the binary logs. A lot faster than doing mysqldump and a lot less likely to lock tables or slow down your database.

[1] http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recover...

Reply on news.ycombinator.com