亲测可用 每天凌晨备份mysql计划任务shell脚本

mkdir -p /home/backup

 vim /etc/crontab 

30 1 * * * root mysqldump -xxxx.mysql.rds.aliyuncs.com -uuser -ppwd dbname | gzip > /home/backup/dbname_`date ‘+%m-%d-%Y’`.sql.gz

35 1 * * * root find /home/backup/* -type f -mtime +60 -exec rm {} \;