Home » Msyql » InnoDB engine status showing disabled in Mysql

InnoDB engine status showing disabled in Mysql

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;
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.

That’s it.

About

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 from last 7 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud