Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
2.4k views
in Technique[技术] by (71.8m points)

mysql查看binlog日志,看不到insert语句

mysql版本是8.0,查看binlog日志,只能看到write——rows,看不到插入的内容是什么,这是为什么image


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

命令少了一个参数, 没有解码出 sql, 你截图下面的 BINLOG 中包含的内容,解码后就是 sql 了.

mysqlbinlog 命令有一个参数 --base64-output 可选参数 [decode-rows|never|auto] 你命令加上 --base64-output=decode-rows 参数运行试试


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...