From: Ed Carp
Date: March 23 1999 10:22pm
Subject: Re: database backups
List-Archive: http://lists.mysql.com/mysql/853
Message-Id: <015501be757b$b058f640$e26980a6@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>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.