Innodb disabled – MySQL – The Linux Student

First check for any disable options for innodb in /etc/my.cnf like
skip-innodb and remove them if there is any. Then restart mysql:

If that doesn’t work, try

# /etc/init.d/mysql 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/mysql start

To check, get into mysql prompt and use the command :

> show engines;

InnoDB is enabled by default. But, MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them, they are recreated, allowing InnoDB to start again.

About Sarath

A Techie from Kochi, India with 8+ years of experience in Linux and Windows server administration. I learn new things almost everyday and I enjoy the fun of learning and sharing my knowledge.