mysql报错:ERROR: Error in Log_event::read_log_event():"Sanity check

来源：互联网发布：蜂窝移动数据已关闭编辑：程序博客网时间：2024/05/16 06:50

执行:mysqlbin -v --base64-output=decode-rows mysql-bin.000002 > 1.log

报：ERROR: Error in Log_event::read_log_event():"Sanity check

查找mysqlbinlog命令

find / -name mysqlbinlog

which mysqlbinlog

/usr/bin/mysqlbinlog

所以直接执行mysqlbin -v --base64-output=decode-rows mysql-bin.000002 > 1.log

用的是 /usr/bin/mysqlbinlog的mysqlbinlog,而我装的是5.7的，所以的用这个mysqlbinlog:

/opt/mysql/mysql-5.7.15-linux-glibc2.5-x86_64/bin/mysqlbinlog

查看mysqlbinlog版本

/opt/mysql/mysql-5.7.15-linux-glibc2.5-x86_64/bin -V

3.4的

/usr/bin/mysqlbinlog -V

3.3的

直接用/opt/mysql/mysql-5.7.15-linux-glibc2.5-x86_64/bin/mysqlbinlog这个mysqlbinlog才对

/opt/mysql/mysql-5.7.15-linux-glibc2.5-x86_64/bin/mysqlbinlog -v --base64-output=decode-rows mysql-bin.000002 > 1.log

这个时候解析出来的binlog就没问题了

阅读全文

0 0