進(jìn)入mysql的bin下,然后使用mysqlbinlog將binlog文件轉(zhuǎn)成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
進(jìn)入mysql的bin下,然后使用mysqlbinlog將binlog文件轉(zhuǎn)成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