解析binlog里记录的events以及mysqlbinlog的使用

SHOW BINARY LOGS;  SHOW MASTER LOGS; SHOW BINLOG EVENTS IN ‘mysql-bin.000087’; SHOW BINLOG EVENTS IN ‘mysql-bin.000087’ FROM 1008;  SHOW BINLOG EVENTS IN ‘mysql-bin.000087’ FROM 1008 limit 2,5; 将解析到的SQL导入文件中 mysqlbinlog --no-defaults --base64-output=decode-rows -vv binlog.000013 > /tmp/bin13.sql 只解析某个库的操作 mysqlbinlog --no-defaults --base64-output=decode-rows -vv --database=testdb binlog.000013 解析指定时间段内的操作 mysqlbinlog --no-defaults --base64-output=decode-rows -vv --start-datetime="2025-01-11 01:00:00" --stop-datetime="2025-01-11 23:59:00" binlog.000008 解析指定pos位点内的操作 mysqlbinlog --no-defaults --base64-output=decode-rows -vv --start-position=204136360 --stop-position=204136499 binlog.000008 在指定库中恢复指定位点间的操作 mysqlbinlog --no-defaults --start-position=204136360 --stop-position=204136499 binlog.000008 | mysql -uroot -pxxxx testdb