Unknown table engine ‘InnoDB’

If You are facing problem with Unknown table engine ‘InnoDB’ on to your mysql Database. You can do following to get rid of this problem.

First look at the ib_logfile0 and ib_logfile1 in /var/lib/mysql.

If they have been set to size different from the default, that probably will prevent mysqld’s startup. The default for innodb_lkog_file_size is 5M.

Add this in my.cnf

[mysqld]
innodb_log_file_size = 12M

And then Proceed by doing following

/etc/init.d/mysql stop

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak # these are your
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak # log files

/etc/init.d/mysql start

 

Related Posts

No Comments Yet.

Leave a Comment