- #!/bin/bash
- #每天早上4点, mysql备份数据 orangleliu
- #chmod 700 backup.sh
- #crontab -e
- #0 4 * * * /home/erya/run/moniter/mysql_backup.sh
- user="radius"
- password=""
- host="localhost"
- db_name="radius"
- #backup directory
- base_dir="/home/backup"
- backup_log="${base_dir}/mysql_backup.log"
- backup_path=${base_dir}
- #file info
- date=$(date +"%Y-%m-%d")
- filename=$backup_path/$db_name-$date.sql.gz
- umask 177
- #back up
- mysqldump --user=$user --password=$password --host=$host $db_name | gzip > $filename
- #Delete files older than 10 days
- find $backup_path/* -mtime +10 -exec rm {} \;
- echo "backup finished at $(date +'%Y-%m-%d %H:%M:%S')" >> "$backup_log"
参考
来源: http://www.phpxs.com/code/1005384/