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/mysqld.pid 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!

Advertisements

2 Comments »

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: