【MySQL 5.7】阿里云rds恢复到本地自建数据库启动报错
1 2 3 4 5 6 7 |
2023-11-02T03:14:56.349269Z 0 [ERROR] InnoDB: Log block 73116952 at lsn 19828645178880 has valid header, but checksum field contains 356100138, should be 26302493 2023-11-02T03:14:56.349304Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 19828645179005 and the end 19828645178880. 2023-11-02T03:14:56.349312Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2023-11-02T03:14:56.950170Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2023-11-02T03:14:56.950204Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2023-11-02T03:14:56.950208Z 0 [ERROR] Failed to initialize builtin plugins. 2023-11-02T03:14:56.950212Z 0 [ERROR] Aborting |
因为自建数据库的参数与rds的参数不一致造成的。
解决方法:直接把ib_logfile0和ib_logfile1这两个文件重命名或者移走即可。