ITPub博客

首页 > 数据库 > MySQL > MySQL闪回技术之binlog2sql恢复binlog中的SQL

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

原创 MySQL 作者:tangyunoracle 时间:2019-12-06 11:13:48 0 删除 编辑

># 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 -h127.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-------------------------------------------------


来自 “ ITPUB博客 ” ,链接:/24930246/viewspace-2667229/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
有空写写一写,没空看一看。。。 微信号:tangyun0925
  • 博文量
    115
  • 访问量
    1743804