binlog2sql icon indicating copy to clipboard operation
binlog2sql copied to clipboard

binlog2sql 无法生成回滚sql

Open JokerDevops opened this issue 7 years ago • 3 comments

[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

为空

JokerDevops avatar Nov 14 '18 06:11 JokerDevops

我的也是为空

lxw1844912514 avatar Jul 04 '20 09:07 lxw1844912514

你们正向解析正常吗?

zsp108 avatar Sep 10 '20 08:09 zsp108

mysql 配置需要配置成:

binlog_format = row
binlog_row_image = full

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

raybon-lee avatar Mar 10 '23 03:03 raybon-lee