【MySQL】InnoDB: Error: checksum mismatch in data file 報錯

標籤：

參考：http://www.jb51.net/article/66951.htm

用5.7版本啟動原5.5執行個體後，再用5.5啟動出現以下報錯

InnoDB: Error: checksum mismatch in data file /data/mysql/ibdata1160627 10:42:11 InnoDB: Could not open or create data files.160627 10:42:11 InnoDB: If you tried to add new data files, and it failed here,160627 10:42:11 InnoDB: you should now edit innodb_data_file_path in my.cnf back160627 10:42:11 InnoDB: to what it was, and remove the new ibdata files InnoDB created160627 10:42:11 InnoDB: in this failed attempt. InnoDB only wrote those files full of160627 10:42:11 InnoDB: zeros, but did not yet use them in any way. But be careful: do not160627 10:42:11 InnoDB: remove old data files which contain your precious data!160627 10:42:11 [ERROR] Plugin ‘InnoDB‘ init function returned error.160627 10:42:11 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.160627 10:42:11 [ERROR] Unknown/unsupported storage engine: InnoDB160627 10:42:11 [ERROR] Aborting160627 10:42:11 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

通過參數可以跳過錯誤啟動，匯出資料

innodb_force_recovery=6innodb_purge_thread=0

【MySQL】InnoDB: Error: checksum mismatch in data file 報錯