binlog2sql

binlog2sql copied to clipboard

解析json字段报错

1

我的语句是这样 python3 binlogfile2sql.py -hxxx -uxxxx -p -Pxxx -d xxxx -t xxxx --sql-type='update' --file-path='/root/tmp_binlog/binlog.004018' --start-datetime='2023-08-17 19:30:00' -B > rollback_xxxxx.sql 报错是  如果我的语句不对，麻烦您给我个例子（解析某张表从某个时间点以来的全部binlog）

liupeipeng

-B > rollback.sql 一直报以下错误 `UnicodeDecodeError: 'utf-8' codec can't decode byte 0xc1 in position 620: invalid start byte` 我修改 sort_binlog2sql_result_utils 里两处encoding ，把utf8改为gb18030才写入成功 ``` // sort_binlog2sql_result_utils.py def yield_file(filename, encoding: str = 'gb18030',...

missy0u

支持windows嘛

1

支持windows嘛

JanHezz

issue with field type 'bit'

2

SQL query was generated with Single quotes `field='XXX'` expect should be `field=1`

peerasan

start-position 不生效

2

start-position 不生效，使用了 `--start-pos= ` 和 `--stop-pos=` 参数不生效，请问是我用法问题，还是一直存在此bug ``` shell python binlogfile2sql.py -h localhost -P3306 -uroot -p'123456' -dry-cloud -t sch_children -f D:/data/mysql-bin.000078 --start-position=334207 --stop-position=26578922 -B > roll_bak.sql ```

Fan-sx

导出数据时异常，ValueError: Json type 121 is not handled

2

异常日志 ``` Traceback (most recent call last): File "binlog2sql/binlog2sql.py", line 375, in main(command_line_args) File "binlog2sql/binlog2sql.py", line 370, in main binlog2sql.process_binlog() File "binlog2sql/binlog2sql.py", line 256, in process_binlog for row in binlog_event.rows:...

gaolc

之前犯了数据库操作的一大戒律：没有备份数据库就运行了source mysql.sql，导致数据库原来的数据被覆盖， 还好找到了大佬的这个项目，几乎完美地复原了数据库，非常感谢！

zgpnuaa