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