How to Fix [ERROR] Unknown/unsupported storage engine: InnoDB

Valic —  January 7, 2013 — 6 Comments

Recently I upgraded the MySQL server and I enabled InnoDB and then I was not able to start the MySQL Server.

The next step was to check the mysql logs and I saw the error:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 5256780 bytes
InnoDB: than specified in the .cnf file 0 1077645824 bytes!
[ERROR] Plugin ‘InnoDB’ init function returned error.
[ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

The solution for this error is:

Remove the ib_logfile0 and ib_logfile1 files located in /var/lib/mysql.

rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1

Then just start the Mysql Server and should be fine now.

root@server# /etc/init.d/mysql start
Starting MySQL database server: mysqld . ..
Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..


Posts Twitter Facebook

Editor in Chief at Debian-Tutorials, Linux enthusiast.

6 responses to How to Fix [ERROR] Unknown/unsupported storage engine: InnoDB

  1. Thank you!

  2. it solved my problem, many thanks!

  3. Rabia Naz Khan August 1, 2016 at 10:22

    Thank you! I deleted whole MySQL folder from C:/Program Data. it also included the above mentioned files and reinstalled MySQL. It worked! *Cheers*

  4. That fixed it, thanks!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.