3 ms·
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-extend
by nimrody 12y ago
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).
- cwyers 12y agoWhy 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-recovery-positions.html http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recover...