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