MySQL闪回技术之binlog2sql恢复binlog中的SQL

># yum remove git
下载git2.2.1并将git添加到环境变量中
># wget https://github.com/git/git/archive/v2.2.1.tar.gz
># tar zxvf v2.2.1.tar.gz
># cd git-2.2.1
># make configure
># ./configure –prefix=/usr/local/git –with-iconv=/usr/local/libiconv
># make all doc
># make install install-doc install-html
># echo “export PATH=$PATH:/usr/local/git/bin” >> /etc/bashrc
># source /etc/bashrc
4.2 安装xmlto
yum install xmlto
查看版本号
># git –version
>git version 2.2.1
[root开发云主机域名@dbtest git]# git clone https://github.com/danfengcao/binlog2sql.git && cd binlog2sql
Cloning into ‘binlog2sql’…
fatal: unable to access ‘https://github.com/danfengcao/binlog2sql.git/’: SSL connect error
解决办法是把https 改成git
[root@dbtest git]# git clone git://github.com/danfengcao/binlog2sql.git && cd binlog2sql
Cloning into ‘binlog2sql’…
remote: Enumerating objects: 323, done.
remote: Total 323 (delta 0), reused 0 (delta 0), pack-reused 323
Receiving objects: 100% (323/323), 151.51 KiB | 88.00 KiB/s, done.
Resolving deltas: 100% (170/170), done.
Checking connectivity… done.
yum install python3 -y
python3 -m pip install pymysql pymysql
cd /usr/local/src
wget 10.70.161.22/python/python-mysql-replication-0.21.tar.gz
tar xf python-mysql-replication-0.21.tar.gz
cd python-mysql-replication-0.21
python3 setup.py install
python3 /app/ty/binlog2sql/binlog2sql/binlog2sql.py -h227.0.0.1 -P3306 -uroot -p’ty#Tangyun’ -dapollo -tt –start-file=’mysql-bin.000004′ –start-datetime=’2019-12-04 14:00:00′ –stop-datetime=’2019-12-04 14:05:00′ > /tmp/binlog_sql.sql
# more /tmp/binlog_sql.sqlUSE b’apollo’;create table t(t1 int,t2 varchar(10));INSERT INTO `apollo`.`t`(`t1`, `t2`) VALUES (1, ‘1’); #start 41133116 end 41133351 time 2019-12-04 14:01:42INSERT INTO `apollo`.`t`(`t1`, `t2`) VALUES (1, ‘t’); #start 41133382 end 41133624 time 2019-12-04 14:02:20INSERT INTO `apollo`.`t`(`t1`, `t2`) VALUES (2, ‘t’); #start 41133382 end 41133624 time 2019-12-04 14:02:20
—————-End By【TangYun】2019-12-06————————————————-

相关推荐: mysql的默认时区如何修改

本篇文章为大家展示了mysql的默认时区如何修改，代码简明扼要并且容易理解，绝对能使你眼前一亮，通过这篇文章的详细介绍希望你能有所收获。一、查看MySQL当前时区和时间#time_zone说明mysql使用system的时区，开发云主机域名system_tim…