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.