I found myself with some spare time the other day and decided that my current mysql backup strategy is not the best in the world. The mysql server is a virtual machine in a Brisbane datacenter and it's backed up via a script that calls mysqldump on each installed database and dumps the content to (compressed) files. These files then get sucked down via rdiff-backup.

This is fine in principle, but does mean it's possible for me to lose 24 hours worth of data due to an accidental '--; DROP table students.

time machine, kinda

With hard disks getting larger by the month, keeping all your data backed up can be tricky. Raid will give you reliability, but no possibility of taking your data off-site, and tape drives are expensive.

I found myself needing to keep backups of an 80GB raid array for a small office server, and recalled an article I had read a few months ago in Linux Journal. The article details how you can keep snapshot backups of thumb drives on your harddisk... and that made me think doing the reverse should be workable too.