A few weeks ago I taught myself another lesson on the need for backups when I deleted the MySQL database behind this site. No backup, no database, no site.
So, in parallel with rebuilding the site, I am also writing a set of cron routines that will use mysqldump to make scheduled copies of all the databases. Then I can download these for offsite copies.
Aargh!