创建脚本
#!/bin/bash db_user="root" db_passwd="root" db_name="data_center" #备份目录 backup_dir="/home/backup/mysql" #时间格式 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 /home/backup/mysql/$db_name-$SevenDays.sql ] then rm -rf /home/backup/mysql/$db_name-$SevenDays.sql echo "you have delete 7days ago bak sql file " else echo "7days ago bak sql file not exist " echo "bash complete" fi
创建定时任务
crontab -e 0 2 * * * cd /root/ && ./data_center.sh