查看binlog模式
SHOW VARIABLES LIKE 'binlog_format';
下载binlog日志
使用mysqlbinlog解析日志
D:\software\mysql-5.7.44-winx64\bin>mysqlbinlog.exe D:\12193\binlog\mysql-bin.110522 -v --base64-output=DECODE-ROWS --result-file D:\12193\binlog\110522.txt
mysqlbinlog.exe 目标binlog文件 -v (格式化sql) --base64-output=DECODE-ROWS (base64)--result-file (输出到目标地址)