mysql增量备份依次恢复库
#!/bin/bash#scripts sh recovery_increment.sh 时间 日期例如: 14 20180228
bakfile=/data/dbbackup
logfile=/data/bak.log
dbuser=xxx
dbpasswd=xxxx
ip=ifconfig | grep "inet addr"| grep Bcast| awk '{print $2}'| awk -F":" '{print $2}'
#增量还原
recoveryincrement()
{
#解压增量备份到的新子目录
mkdir -p $bakfile/test
cd $bakfile/test
tar -xf $bakfile/$2${ip}_$1.DailyBak.tar.gz
cd daily
#把二进制的binlog文件转成sql，按最早的时间开始转换sql
mysqlbinlogmysql-bin.000602 >> #如果有好几个增量备份,用到追加
mysqlbinlogmysql-bin.000603 >>>
mysql-u$dbuser -p$dbpasswd echo "导入完成"
if [ -f> then
echo "ida.sql 存在"
else
echo "ida.sql don't exist"
exit 1
fi
}
recovery_increment$1 $2
页:
[1]