进入mysql的bin下,然后使用mysqlbinlog将binlog文件转成txt文件
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysqlbinlog --base64-output=decode-rows -v --set-charset=utf8 D:\WIN-PC872KJLVH1-bin.000023 > D:\binlog2.txt
进入mysql的bin下,然后使用mysqlbinlog将binlog文件转成txt文件
cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysqlbinlog --base64-output=decode-rows -v --set-charset=utf8 D:\WIN-PC872KJLVH1-bin.000023 > D:\binlog2.txt