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.
Similar Posts:
- [Solved] MYSQL8 Error: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- Does MySQL report an error “MySQL: unknown option” for all parameters
- ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded
- How to Sovle mysqldump backup Error on the MySQL command line
- How to Solve MySQL Errno:1782 Error
- MySQL 5.7 installation, mysql. Plugin ‘doesn’t exist error resolution
- [Solved] MySQL ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- PHP Connect MYSQL8.0 Error: Server sent charset unknown to the client. Please, report to the developers
- ERROR 1820 (HY000): Unknown error 1820 [How to Solve]
- MYSQL: You must reset your password using ALTER USER statement before executing this statement.[How to Solve]