mysql每日备份shell脚本

2015/07/22 39385

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

每天固定时间用mysqldump 备份mysql数据。
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
#!/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://blog.csdn.net/orangleliu/article/details/46652819