Home / server / Questions / 248882
In Process
webminal.org
Asked: 2011-03-18 22:16:00 +0800 CST

mysql queries not working suddenly !

  • 772

When I do simple select or insert it says-

Unknown table engine InnoDB

It was working properly just few days back.what it's suddenly gone wrong ?

mysql innodb

2 Answers

  1. There are several reasons. Are you sure you've not changed anything (configs, updates?).

    Check following:

    1) Make sure you don't have skip-innodb in your mysql file.

    2) InnoDB might be used via plugin, this may be your situation. Connect to mysql, execlute SHOW PLUGINS and SHOW ENGINES. This would give some info. You might need to install innodb plugin(s):

    INSTALL PLUGIN INNODB SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_TRX SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_LOCKS SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_LOCK_WAITS SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMP SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMP_RESET SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMPMEM SONAME 'ha_innodb_plugin.so';
INSTALL PLUGIN INNODB_CMPMEM_RESET SONAME 'ha_innodb_plugin.so';

    You might also need to reinstall/recompile plugins if they were deleted for some reason.

    • 3

  2. Check your MySQL error log. If there are InnoDB related errors, the InnoDB table engine gets disabled.

    • 3