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