search

danfengcao / binlog2sql

Parse MySQL binlog to SQL you want
GNU General Public License v3.0
3.32k stars 1.04k forks source link

binlog2sql 无法生成回滚sql #42

Open JokerDevops opened 6 years ago

JokerDevops commented 6 years ago

[root@test test]# binlog2sql-master/binlog2sql/binlog2sql.py -h localhost -P 3306 -u root -p -d aproject --start-file="mysql-bin.000001" --start-datetime="2018-11-13 17:00:00" --stop-datetime="2018-11-13 19:00:00" -B > huifu4.sql [root@test test]# cat huifu4.sql

为空

lxw1844912514 commented 4 years ago

我的也是为空

zsp108 commented 4 years ago

你们正向解析正常吗？

raybon-lee commented 1 year ago

mysql 配置需要配置成：

binlog_format = row
binlog_row_image = full

binlog_format = mixed 模式 这个无法解析回滚sql