Skip to content

加结束位置参数pos不能解析出SQL #5

@oracle-sky

Description

@oracle-sky

我的事务

at 31405

delete from t1

at 31727

commt;

.my2sql -user root -password 'xxx' -host 127.0.0.1 -port 3306 -work-type rollback -mode repl -start-file mysql-bin.000001 -start-pos 31405 -stop-file mysql-bin.000001 -stop-pos 31727 -output-dir ./tmpdir1

./my2sql -user root -password 'xxx' -host 127.0.0.1 -port 3306 -mode file -local-binlog-file ./mysql-bin.000001 -work-type 2sql -start-file mysql-bin.000001 -start-pos 31405 -stop-file mysql-bin.000001 -stop-pos 31727 -output-dir ./tmpdir

查看tmpdir目录 没有forward.sql
biglong_trx.txt
binlog_status.txt
original_sql.sql

问题 在加参数 -stop-file -stop-pos 后,是不能解析出SQL的。

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions