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.sql

USE 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:42

INSERT INTO `apollo`.`t`(`t1`, `t2`) VALUES (1, 't'); #start 41133382 end 41133624 time 2019-12-04 14:02:20

INSERT 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-------------------------------------------------