Plugin InnoDB registration as a storage engine failed solution

This article introduces the Plugin InnoDB registration as a storage engine failed solution. I hope this article will help some friends who encounter such problems.

The Innodb ENGINE was not installed on a database. We added it dynamically today and found that innodb cannot be loaded. The error "Plugin 'innodb' registry as a storage engine failed" is reported, the log file creation failed to be found in the detailed log. The detailed log is as follows:

The Code is as follows:

Copy code

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 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' registry as a storage engine failed.

In fact, innodb was loaded on this server before, but it was removed later, but the logfile file was not deleted, resulting in this problem during the re-loading. The solution is simple.

The Code is as follows:	Copy code
Rm-rf ib_logfile *

Load innodb again dynamically. If not, restart mysql.