The InnoDB requires access to specific files, that if are corrupted, will cause the InnoDB engine to fail to load. You will know if the InnoDB fails to load if you acess MySQL and run the following command;
show engine innodb status;
The output will be the following;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined
However the fix is to locate the following files in /var/lib/mysql/. Be sure to stop MySQL first before changing the files;
You can remove both the files by running the following commands. Again, be sure to stop MySQL first;
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
(Your MySQL pathing may vary, we are using the default MySQL install paths in this article).
After removing these files, start up MySQL;
Service mysql start or Service mysqld start.
Once the MySQL instance is started, the InnoDB will also be started as well.Tags: innodb, MySql