Wallogit.com
2017 © Pedro Peláez
library binlog2sql
A tool to change binlog to sql
nine/binlog2sql
A tool to change binlog to sql
- Sunday, August 6, 2017
- by nineyang
- Repository
- 1 Watchers
- 4 Stars
- 14 Installations
- PHP
- 0 Dependents
- 0 Suggesters
- 1 Forks
- 0 Open issues
- 2 Versions
- 56 % Grown
The README.md
介绍
这是一个可以帮助我们把我们的binlog文件的内容转换为可识别的sql语句的工具包。, (*1)
安装
- composer 安装
composer require nine/binlog2sql
- 直接下载 clone 下来即可。
使用
首先在Conf.php中配置自己的MySql信息:, (*2)
const __DATABASE__ = 'test'; const __TABLE__ = 'student'; const __USER__ = 'root'; const __PASSWORD__ = 123456; const __HOST__ = '127.0.0.1'; const __PORT__ = 3309;
调用Binlog的start方法:, (*3)
$binlog = new \Binlog2sql\Binlog(); $binlog->start();
其中start方法可以写入一些参数，比如设置起始时间和起始position，或者指定的表。, (*4)
nine