The original database did not have the InnoDB engine installed, today dynamically increased him, found InnoDB load, error plugin ' InnoDB ' registration as a STORAGE ENGINE, from the detailed log found in the creation of File creation failed. The detailed log is as follows:
code is as follows |
copy code |
Innodb:if This error appears when you are creating a InnoDB database, innodb:the problem May is that during a earlier T you managed Innodb:to create the InnoDB data files, but log file creation failed. Innodb:if That's the case, refer to Innodb:http://dev.mysql.com/doc/refman/5.1/en/error-creating-innod b.html 131017 0:45:52 [ERROR] Plugin ' InnoDB ' init function returned ERROR. 131017 0:45:52 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE. |
In fact, before this server has loaded InnoDB, and then unloaded, but logfile file has not been deleted, resulting in the new load when this problem occurs. The solution is simple
The code is as follows |
Copy Code |
RM-RF ib_logfile* |
Then dynamically load the InnoDB again, if not, then restart MySQL.