binlog_parse_to_sql

binlog python解析 MySQL_Binlog_Parse_to_sql 单表导出 #工具运行步骤 1.binlog—format= row 2.mysqlbinlog --no-defaults --base64-output=decode-rows -v -v mysql-bin.00000x >mysql-bin.00000x.sql 3.python script_name.py -u user -p password -f mysql-bin.00000x.sql -b binlog_to_sql.sql

#工具HELP ===Author:GuiJiaoQi&XuYou ======= ===For Example:python ts.py -u user -p password -f mysql-bin.00000x.sql -b binlog_to_sql.sql ======= === :python ts.py -u user -p password -t tb_name -f mysql-bin.00000x.sql -a single_tb_.sql =======

Usage: ts.py [options]

  Options:
    -h, --help            show this help message and exit
    -u USER, --user=USER  User for login
    -p PASSWORD, --password=PASSWORD
                          Password to use when connecting
    -s SOCKET, --socket=SOCKET
                          The socket file to use for connection.
    -f FILE, --file=FILE  incoming parse binlogfile For Example:mysqlbinlog
                          --no-defaults --base64-output=decode-rows -v -v mysql-
                          bin.00000x
    -b binlog, --report=binlog
                          write format binlog to normal sql
    -a TB_FILE, --single-tables-file=TB_FILE
                          grep single table to normal sql file
    -t TABLE, --table=TABLE
                          specify table