binlog2sql icon indicating copy to clipboard operation
binlog2sql copied to clipboard

增加本地binlog解析

Open xuyi opened this issue 8 years ago • 10 comments

新增bin2sql.py工具解析本地binlog文件,-f指定本地文件

xuyi avatar Apr 11 '17 03:04 xuyi

喔哦,让人激动的patch!我稍后测试哈

danfengcao avatar Apr 11 '17 10:04 danfengcao

好棒 这个好

orangle avatar Jun 26 '17 11:06 orangle

Traceback (most recent call last): File "bin2sql.py", line 13, in from binlog2sql_util import concat_sql_from_binlogevent, create_unique_file, reversed_lines ImportError: cannot import name concat_sql_from_binlogevent

ca2ju3 avatar Dec 21 '17 06:12 ca2ju3

这个pr合并了吗?

leafonsword avatar Jan 08 '18 03:01 leafonsword

the funciton is good

wqfgithub avatar Jan 10 '18 09:01 wqfgithub

Traceback (most recent call last): File "bin2sql.py", line 6, in from binlogfile import BinLogFileReader File "/Users/janyd/Documents/project/source/binlog2sql/binlog2sql/binlogfile.py", line 13, in from pymysqlreplication.event import ( ImportError: cannot import name HeartbeatLogEvent

Janyd avatar May 10 '18 11:05 Janyd

这个补丁合并到主线上了吗??我试了-f参数目前是不支持的啊。

luyaotang avatar Aug 16 '18 06:08 luyaotang

请问这个补丁合并了吗

huxiaoqiao avatar Jul 15 '19 14:07 huxiaoqiao

由于还没有合并,而且只支持python2,所以要使用的话,得

pip install  mysql-replication

git fetch origin pull/13/head:local_file_parse

git co local_file_parse

使用方法

python2 bin2sql.py -h127.0.0.1 -P3306 -uadmin -p'admin' -dtest -t test3 test4 --f='mysql-bin.000002'

mrzhangboss avatar Oct 24 '19 04:10 mrzhangboss

这个补丁真棒👍

362228416 avatar Nov 12 '19 17:11 362228416