Error:error in Log_event::read_log_event (): ' Found invalid event in binary Log ', data_len:77, even

Today, using Mysqlbinlog to recover data, this error has been encountered:

Error:error in Log_event::read_log_event (): ' Found invalid event in binary Log ', data_len:77, event_type:19
Could not read entry at offset 306709:error in log format or read Error

After searching the internet, found that the default is to call the system installed by default Mysqlbinlog MySQL, because this mysqlbinlog version and the current version of the Bin_log can not correspond, so can not be processed, Use the corresponding Mysqlbinlog to work properly.

Using commands:/usr/local/mysql/bin/mysqlbinlog mysql-bin.000004 >>/tmp/bin.sql

Run successfully.

--This article is from: Error:error in Log_event::read_log_event ()