First, the problem description
MySQL v 5.0.91
[Email protected] bin]#./mysqlbinlog/tmp/mysql-bin.000015
/
!40019 SET @ @session. max_insert_delayed_threads=0/;
/
!50003 SET @[email protected] @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:55
Error:error in Log_event::read_log_event (): ' Found invalid event in binary Log ', data_len:69, Event_type:2
Could not read entry on offset 98:error in log format or read Error
DELIMITER;
#End of log file
ROLLBACK/
added by Mysqlbinlog/;
/
!50003 SET [email protected]_completion_type/;
Second, the solution
Remove the default character set
#vim/etc/my.cnf
[Client]
#default-character-set = UTF8
#character-set-server = UTF8
#password = Your_password
Port = 3306
Socket =/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
Mysql:mysqlbinlog read binary file Error read_log_event ()
