一、问题描述

mysql v 5.0.91[root@localhost bin]# ./mysqlbinlog /tmp/mysql-bin.000015 /!40019 SET @@session.max_insert_delayed_threads=0/;/!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0/;DELIMITER /!/;#at 4#180227 10:31:55 server id 1 end_log_pos 98 Start: binlog v 4, server v 5.0.91-log created 180227 10:31:55ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 69, event_type: 2Could not read entry at offset 98:Error in log format or read errorDELIMITER ;#End of log fileROLLBACK / added by mysqlbinlog /;/!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE/;

二、解决方法

去掉默认字符集#vim /etc/my.cnf [client]#default-character-set = utf8#character-set-server = utf8#password = your_passwordport = 3306socket = /var/mysql/mysql.sock……[mysqld]datadir=/var/lib/mysql#default-character-set = utf8#character-set-server = utf8……[mysql]no-auto-rehash#default-character-set = utf8