The InnoDB by default enabled. But sometime it automatically disabled due to uncleanly shutdown or any other reasons.
To view the Innodb status in mysql.
#mysql -u root -p
mysql> show engines;
mysql> show engines;
InnoDB |DISABLED
1. To resolve the problem append the below line in my.cnf file.
#skip-innodb
then restart mysql service.
#/etc/init.d/mysqld restart
If the problem persist then do as below.
#/etc/init.d/mysqld stop
#mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
#mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
#/etc/init.d/mysqld start.
#mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak
#mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak
#/etc/init.d/mysqld start.
That’s it.
I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry since more than 14 years.
