Shulou(Shulou.com)06/01 Report--

> # yum remove git

Download git2.2.1 and add git to the environment variable

> # 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 install xmlto

Yum install xmlto

View version number

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

The solution is to change https to 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 KiB), 151.51 KiB/s, done.

Resolving deltas: 100% (170amp 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-pendant typewriter Tangyun'-dapollo-tt-- start-file='mysql-bin.000004'-- start-datetime='2019-12-04 14 purge 0000'-stop-datetime='2019-12-04 14purl 05purl 00' > / tmp/binlog_sql.sql

# more / tmp/binlog_sql.sql

USE breadapollo'

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.