MySQL Backup

[admin at kclinux.net]

http://www.hotscripts.com/Detailed/18002.html

-----Original Message-----
From: owner-kclug at kclug.org [mailto:owner-kclug at kclug.org] On Behalf Of Jim
Herrmann
Sent: Saturday, March 27, 2004 12:29 AM
To: kclug
Subject: MySQL Backup

Anyone have a script to create MySQL backups with mysqldump?  Something 
that builds on something like this:

mysqldump dbname | gzip > /archive/directory/dbname.2004-03-26.gz

Then proceeds to purge the backups that are older then a certain 
retention period.

I just thought I'd ask before I dug into doing it myself.  I'm lazy, I 
know.  Any other MySQL backup tips or quirks would be welcome as well.

Thanks,
Jim