Wednesday, March 27, 2013

Innodb disabled

First check and remove any disable options for innodb in /etc/my.cnf and restart mysql:
Eg: skip-innodb

If that doesn't work, try
#/etc/init.d/mysql stop
#mv /var/lib/mysql/ib_logfile0 /home/ib_logfile0.bak
#mv /var/lib/mysql/ib_logfile1 /home/ib_logfile1.bak

#/etc/init.d/mysql start

InnoDB is enabled by default. But, MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them and restart MySQL, they are recreated and will allow InnoDB to start again. 
Modified the post: MySQL innodb log files can be moved to /home or any other folder except /var/lib/mysql

No comments:

Post a Comment