萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> mysql教程 >> Plugin InnoDB registration as a STORAGE ENGINE failed解決方法

Plugin InnoDB registration as a STORAGE ENGINE failed解決方法

本文章給大家介紹Plugin InnoDB registration as a STORAGE ENGINE failed解決方法,希望此文章對碰到此類問題的朋友有些幫助。

原先一台數據庫未安裝Innodb引擎,今天動態增加他,發現innodb加載不了,報錯Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed,從詳細日志裡面發現創建log file創建失敗。詳細日志如下:

 代碼如下 復制代碼

InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
131017  0:45:52 [ERROR] Plugin 'InnoDB' init function returned error.
131017  0:45:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.


其實之前這台服務器有加載過innodb,後來卸掉了,但是logfile文件沒有刪除,導致從新加載的時候出現這個問題。解決方法很簡單

 代碼如下 復制代碼

rm -rf ib_logfile*

然後重新動態加載一次innodb即可,如果不行,那麼重啟一下mysql.

copyright © 萬盛學電腦網 all rights reserved