mysql增量备份二进制日志shell脚本
来源:互联网 发布:单片机软件外包 编辑:程序博客网 时间:2024/05/29 05:58
#!/bin/bash# Date:2017-10# Description:backup mysql binary logs# Version:0.1 db_user="root"myisam_db="mysql"db_passwd="123456"host="localhost"export PATH="/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin"backup_dir="/opt/backup/mysql/bin"log_file="/opt/backup/mysql/bin/bin_log_file.log"bin_index="/mydata/data/mysql-bin.index"data_dir="/mydata/data"mysql="$(which mysql)"$mysql -u$db_user -h$host -p$db_passwd -e "flush logs"num=$(awk 'END{print NR}' $bin_index)counter=0 start_time=$(date +"%F %H:%M:%S")[ ! -d $backup_dir ] && mkdir -p $backup_dir[ ! -f $log_file ] && touch $log_fileecho "Starting backup mysql binary logs at $start_time" >>$log_filefor file in `cat $bin_index`do base=`basename $file` counter=$(expr $counter + 1) if [ $counter -eq $num ];then echo "Skip $base" >>$log_file else if [ ! -f $backup_dir/$base ];then cp -a $data_dir/$base $backup_dir 2>>$log_file if [ $? -eq 0 ];then echo "Backup $base successfully" >>$log_file else echo "Backup $base failed" >>$log_file echo "Backup $base to $backup_dir failed"|mail -s "MySQL binary logs backup failed" root@localhost fi fi fidonestop_time=$(date +"%F %H:%M:%S")echo "End backup mysql binary logs at $stop_time" >>$log_fileecho " " >>$log_fileexit 0
阅读全文
0 0
- mysql增量备份二进制日志shell脚本
- mysql---二进制日志(增量备份)
- shell脚本实现mysql数据增量备份
- MySQL增量备份脚本和异地备份脚本【Shell】
- Mysql 增量备份脚本 innobackupex 增量备份 mysql自动备份
- Mysql 增量备份脚本(Linux)
- Mysql 增量备份脚本(Linux)
- mysql增量备份及备份脚本
- Mysql学习第三课-分析二进制日志进行增量备份和还原
- MySQL数据库之全量+增量+二进制日志的备份与恢复
- [mysqldump] mysqldump全量备份+mysqlbinlog二进制日志增量备份
- mysql备份shell脚本
- shell脚本备份nginx日志
- mysql全量、增量备份脚本
- mysql全量和增量备份脚本
- 增量dump mysql的shell脚本
- 【shell脚本】mysql每日备份shell脚本
- mysql备份shell脚本(2)
- 3-4·Linux中附加权限、粘滞位权限
- easyUi
- dubbo 依赖包 javassist 版本异常
- Failed to execute goal org.springframework.boot:spring-boot-maven-plugin:1.4.2.RELEASE:repackage (de
- linux单用户模式
- mysql增量备份二进制日志shell脚本
- 计算机网络原理第二章学习总结
- 新手村 Boss战-入门综合练习2 小鱼会有危险吗
- 理解javascript中的递归
- 泛洪攻击的几种方法解析
- CSDN积分获得方式总结
- 360浏览器设置代理服务器
- 复习六:java基础知识点
- poj3276(开关问题)