Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

I got the below error while restarting mysql service after updating the my.cnf file :

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

Just followed the below steps to resolve the issue :

cd /var/lib/mysql
mv ibdata1 ib_logfile0 ib_logfile1 /tmp/

Note that my datadir was /var/lib/mysql. Change the location accordingly.

service mysqld restart

[root@theg-01 mysql]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

Thats it 🙂

Advertisements

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