?

Log in

No account? Create an account

TimeCapsule'ish Backups, MySQL

« previous entry | next entry »
May. 21st, 2008 | 06:19 pm

A while ago I blogged about using Mercurial as a backup repository for my databases. I was asked about this again
last night over dinner.

This is an example of what I see via the web:
Picture 13.png



I can see both changes to schema, and do deltas between days (aka slice out a days worth of data or grab a snapshot of anyone one particular days data). The nice thing with hgweb is that I can make this happen via my browser :)

Part of what really makes this work is the --tab option to mysqldump (I also use Innodb so my backups are all done online). I can compress it, but frankly disk is cheap and storing deltas is cheap :)

Link | Leave a comment |

Comments {2}

awfief

(no subject)

from: awfief
date: May. 23rd, 2008 02:38 pm (UTC)
Link

oh yeah, re: compression -- disk is cheap, plus when you want a restore you don't want to have to wait for the uncompression.

Reply | Thread