Mani's Blog

August 31, 2011

MySQL: Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

Filed under: MySQL — mani @ 9:27 pm

Problem: After restoring the databases, Initially I started  mysql with incorrect and  ran into error in the error log.

110831 21:20:00 [ERROR] Plugin ‘InnoDB’ init function returned error.
110831 21:20:00 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
110831 21:20:00 [ERROR] Unknown/unsupported storage engine: INNODB
110831 21:20:00 [ERROR] Aborting

110831 21:20:00 [Note] /usr/sbin/mysqld: Shutdown complete

110831 21:20:00 mysqld_safe mysqld from pid file /local/mysql/data/ ended

Solution: Go to the data directory and remove log files look like ib_logfile0, ib_logfile1 and ib_logfile2.  Then start mysql, this fixed the issue.

/local/mysql/data#/etc/init.d/mysql start
Starting MySQL……….. SUCCESS!



  1. Fine way of explaining, and fastidious paragraph to get data about my presentation subject matter, which i am going to convey in academy.

    Comment by orthodontia — September 13, 2012 @ 5:01 am | Reply

  2. Thanks for info

    Comment by MyStudentSQL — December 31, 2012 @ 2:56 pm | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Blog at

%d bloggers like this: