Plugin 'InnoDB' registration as a STORAGE ENGINE failed 错误处理

Plugin 'InnoDB' registration as a STORAGE ENGINE failed，从详细错误日志里面发现创建log file创建失败。详细日志如下：

1 2 3 4 5 6 7

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文件没有删除，导致从新加载的时候出现这个问题。解决方法很简单
进入mysql数据路径
/var/lib/mysql

1	rm - rf ib_logfile*

mysql服务重启

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30127122/viewspace-2103847/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30127122/viewspace-2103847/