mysql增量备份二进制日志shell
exit?0
echo?"?"?>>$log_file
echo?"End?backup?mysql?binary?logs?at?$stop_time"?>>$log_file
stop_time=$(date?+"%F?%H:%M:%S")
done
fi
fi
fi
echo?"Backup?$base?to?$backup_dir?failed"|mail?-s?"MySQL?binary?logs?backup?failed"?root@localhost
echo?"Backup?$base?failed"?>>$log_file
else
echo?"Backup?$base?successfully"?>>$log_file
if?[?$??-eq?0?];then
cp?-a?$data_dir/$base?$backup_dir?2>>$log_file
if?[?!?-f?$backup_dir/$base?];then
else
echo?"Skip?$base"?>>$log_file
if?[?$counter?-eq?$num?];then
counter=$(expr?$counter?+?1)
base=`basename?$file`
do
for?file?in?`cat?$bin_index`
echo?"Starting?backup?mysql?binary?logs?at?$start_time"?>>$log_file
[?!?-f?$log_file?]?&&?touch?$log_file
[?!?-d?$backup_dir?]?&&?mkdir?-p?$backup_dir
start_time=$(date?+"%F?%H:%M:%S")
counter=0
num=$(awk?‘END{print?NR}‘?$bin_index)
$mysql?-u$db_user?-h$host?-p$db_passwd?-e?"flush?logs"
mysql="$(which?mysql)"
data_dir="/mydata/data"
bin_index="/mydata/data/mysql-bin.index"
log_file="/opt/backup/mysql/bin/bin_log_file.log"
backup_dir="/opt/backup/mysql/bin"
export?PATH="/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin"
host="localhost"
db_passwd="123456"
myisam_db="mysql"
db_user="root"
#?Version:0.1
#?Description:backup?mysql?binary?logs
#?Date:2017-10
#!/bin/bash
mysql增量备份二进制日志shell脚本
mysql增量备份二进制日志shell
原文:http://blog.51cto.com/11829889/2048911
来源: http://www.bubuko.com/infodetail-2422124.html