Mysql数据闪回的奇技淫巧(binlog2sql)

iyth888

[root@DB binlog2sql-master]# wget  https://codeload.github.com/danfengcao/binlog2sql/zip/master　　
[root@DB install_page]# unzip binlog2sql-master.zip
　　
Archive:  binlog2sql-master.zip
　　
bb09b8f9079ca4d3cacd0186f35ddf4b3e1cfa7e
　　
   creating: binlog2sql-master/
　　
  inflating: binlog2sql-master/.gitignore
　　
  inflating: binlog2sql-master/LICENSE
　　
  inflating: binlog2sql-master/README.md
　　
   creating: binlog2sql-master/binlog2sql/
　　
  inflating: binlog2sql-master/binlog2sql/__init__.py
　　
  inflating: binlog2sql-master/binlog2sql/binlog2sql.py
　　
  inflating: binlog2sql-master/binlog2sql/binlog2sql_util.py
　　
   creating: binlog2sql-master/example/
　　
  inflating: binlog2sql-master/example/mysql-flashback-priciple-and-practice.md
　　
  inflating: binlog2sql-master/requirements.txt
　　
   creating: binlog2sql-master/tests/
　　
  inflating: binlog2sql-master/tests/test_binlog2sql_util.py
　　
[root@DB install_page]# ls
　　
binlog2sql-master  binlog2sql-master.zip
　　
[root@DB binlog2sql-master]# cd binlog2sql-master #下面脚本执行的时候也要在这么路径下
　　
[root@DB binlog2sql-master]# pip install -r requirements.txt
　　
Downloading/unpacking PyMySQL==0.7.11 (from -r requirements.txt (line 1))
　　
  Downloading PyMySQL-0.7.11.tar.gz (71kB): 71kB downloaded
　　
  Running setup.py egg_info for package PyMySQL
　　
Downloading/unpacking wheel==0.29.0 (from -r requirements.txt (line 2))
　　
  Downloading wheel-0.29.0.tar.gz (54kB): 54kB downloaded
　　
  Running setup.py egg_info for package wheel
　　
    no previously-included directories found matching 'wheel/test/*/dist'
　　
    no previously-included directories found matching 'wheel/test/*/build'
　　
Downloading/unpacking mysql-replication==0.13 (from -r requirements.txt (line 3))
　　
  Downloading mysql-replication-0.13.tar.gz
　　
  Running setup.py egg_info for package mysql-replication
　　
Installing collected packages: PyMySQL, wheel, mysql-replication
　　
  Running setup.py install for PyMySQL
　　
  Running setup.py install for wheel
　　
    no previously-included directories found matching 'wheel/test/*/dist'
　　
    no previously-included directories found matching 'wheel/test/*/build'
　　
    Installing wheel script to /usr/bin
　　
  Running setup.py install for mysql-replication
　　
Successfully installed PyMySQL wheel mysql-replication
　　
Cleaning up...