XY BLOG

XY的BLOG

MySQL binlog查看筛选

Published on in Posts
Updated on
Short link: https://b.xyzt07.cn/s/13
Share this post
A ⇄ 文
⚠️ This entry is already over one year old. It may no longer be up to date. Opinions may have changed.

查看信息 mysqlbinlog –start-datetime=‘2023-11-01 23:54:21’ –stop-datetime=‘2023-11-01 23:55:21’ -vv -d {databasename} mysql-bin.000004;

可选参数 -vv 查看详细信息

–base64-output=DECODE-ROWS -v 查看编码的执行的sql