Today, while reviewing MySQL's binary logs, a bit of a problem was found, as follows:
mysqlbinlog-uroot-proot/usr/local/mysql/data/node1.000004--start-datetime= "2016-05-04 13:30:00"--stop-datetime= "2016-05-04 13:45:00" > A.sql
Error:error in Log_event::read_log_event (): ' Sanity check failed ', data_len:171, event_type:30
Error:could not read entry at offset 1009:error in log format or read Error.
Check the instructions on the Internet, said that the current environment variable under the Mysqlbinlog version and the current version of MySQL is not the same result. Just add the global path. "Description: I used to install MariaDB10.0.12 on this virtual machine, then replaced it with MySQL5.6"
As follows:
/usr/loca/mysql/bin/mysqlbinlog-uroot-proot/usr/local/mysql/data/node1.000004--start-datetime= "2016-05-04 13:30:00 "--stop-datetime=" 2016-05-04 13:45:00 "> A.sql
This will enable you to perform the backup correctly.
Mysqlbinlog Backup time error sanity check failed