#!/bin/bashdb_user="root"db_passwd="123456"db_name="test_db"#进入备份目录将之前的移动到old目录cd /mnt/backup/bakmysqlecho "you are in bakmysql directory now"mv test_db* /mnt/backup/bakmysqloldecho "Old databases are moved to bakmysqlold folder"#备份目录backup_dir="/mnt/backup/bakmysql"#时间格式time=$(date +"%Y-%m-%d")#mysql 备份的命令，注意有空格和没有空格mysqldump -u$db_user -p$db_passwd $db_name  > "$backup_dir/$db_name"-"$time.sql"echo "your database backup successfully completed"#这里将7天之前的备份文件删掉SevenDays=$(date -d -7day  +"%Y-%m-%d")if [ -f /mnt/backup/bakmysqlold/pashanhu-$SevenDays.sql ]thenrm -rf /mnt/backup/bakmysqlold/pashanhu-$SevenDays.sqlecho "you have delete 7days ago bak sql file "elseecho "7days ago bak sql file not exist "echo "bash complete"fi

然后通过下面命令将脚步加入系统的计划任务

crontab -e0 2 * * * cd /usr/sbin/ && ./bakmysql.sh

保存退出以后就可以了。

也许需要重启crontab  启用命令：/sbin/service crond restart

后期更改~结果如下