trx
Published on 2024-08-12 / 39 Visits
0

mysq row格式binlog日志转成sql

mysqlbinlog --base64-output=decode-rows -v ./mysql-bin.xxxx --result-file=xxx.sql

# 按时间点导出
mysqlbinlog --start-datetime="2024-05-28 15:40:07" --stop-datetime="2024-05-28 15:40:08" --base64-output=decode-rows -v LAPTOP-Q5I1GAE8-bin.000010 --result-file=1111.sql