Error Sanity check failed during mysqlbinlog backup

Error Sanity check failed during mysqlbinlog backup

When I reviewed MySQL binary logs today, I found some problems:
Mysqlbinlog-uroot-proot/usr/local/mysql/data/node1.000004 -- start-datetime = "13:30:00" -- stop-datetime = "13:45:00"> a. SQL

ERROR: Error in Log_event: read_log_event (): 'sanity check failed ', data_len: 171, event_type: 30
ERROR: cocould not read entry at offset 1009: Error in log format or read error.

I checked the instructions on the Internet, that is, the version of mysqlbinlog under the current environment variable is different from the current MySQL version. You only need to add the Global Path. [Note: I have installed MariaDB10.0.12 on this virtual machine before and changed it to MySQL5.6]
As follows:

/Usr/loca/mysql/bin/mysqlbinlog-uroot-proot/usr/local/mysql/data/node1.000004 -- start-datetime = "13:30:00" -- stop-datetime = "13:45:00 ">. SQL

In this way, the backup can be correctly executed.

Mysqlbinlog parsing binlog garbled issue decryption

Use mysqlbinlog to extract binary logs

Use mysqlbinlog to restore data based on location or time point

For information about binlog, see MySQL Binary Log)

This article permanently updates the link address: