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