Today, when using mysqlbinlog to recover data, various problems are always reported, one of which is
ERROR 1105 (HY000) at line 152: Unknown error
The commands I use are as follows:
mysqlbinlog mysql-bin.000015|mysql -uroot -pxxxx -P3306
Later, thinking about narrowing the scope, we can only restore the common library and add the – D parameter.
mysqlbinlog -d common mysql-bin.000015|mysql -uroot -pxxxx -P3306
After executing all logs, the data returned to normal.