急等,求MYSQL大牛赐教!!!!
root@NCBCNMATEST 20131210]# mysqlbinlog 20131210mysql-bin.000087 > 87.sql
ERROR: Error in Log_event::read_log_event(): 'Sanity check failed', data_len: 66130, event_type: 89
ERROR: Could not read entry at offset 308: Error in log format or read error.
我查了一下版本
[root@NCBCNMATEST 20131210]# /usr/local/mysql/bin/mysqlbinlog -V
/usr/local/mysql/bin/mysqlbinlog Ver 3.3 for unknown-linux-gnu at x86_64
[root@NCBCNMATEST 20131210]# /home/oper/soft/mysql-5.1.30/mysql-5.1.30/client/.libs/mysqlbinlog -V
/home/oper/soft/mysql-5.1.30/mysql-5.1.30/client/.libs/mysqlbinlog Ver 3.3 for unknown-linux-gnu at x86_64
版本没有问题。
我把my.cnf文件中的max_allowed_packet也改大了,但是还是报同样的错误。
请大牛指教啊!