linux 定时任务crontab 执行数据库每日备份删除大于7天

mysql_bak_oa.sh 文件

db_user="oa"
db_passwd="oa!@#$%^"
time="$(date +"%Y%m%d%H%M%S")"   
db_name="oa"

# the directory for story your backup file.you shall change this dir
backup_dir="/home/oa/mysql-bak"
# date format for backup file (dd-mm-yyyy)
  
# mysqldump may be error cause by version problem
# use full path solution :  /usr/local/mysql/bin/mysqldump -u...
mysqldump -u$db_user  -p$db_passwd $db_name  > "$backup_dir/$db_name$time"
# additional executable rigths
chmod 777 "$backup_dir/$db_name$time"
# find files older than 7 days(does not exists today) and delete
# -mtime 7
find $backup_dir -name "oa*" -type f -mtime +7 -exec rm {} \; > /dev/null 2>&1

linux

add execute permission to file
chmod +x mysql_bak_oa.sh

view crontab list

crontab -l
edit crontab
crontab -e

0 1 * * * /home/oa/mysql-bak/mysql_bak_oa.sh

restart crontab need root account

service crond restart