MySQL Backup

Jim Herrmann kclug at ItDepends.com
Sat Mar 27 06:29:23 CST 2004


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




More information about the Kclug mailing list