Re: database backups

[Ed Carp]

>A little off topic, I use a cron job that pipes the output of mySQL dumps
>for each installed database into PGP then gzip and finally mail which send
>the encrypted, compressed DBs OFFSITE for additional security.


Since disk is so cheap, I lock my production database tables, run mysqldump
to output to another drive, then unlock, then run gzip to compress the
snapshot.  I've only got ~50 MB in the database, so it doesn't take very
long.