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 ?

  • thanks guys for your response.I found out the problem was due selinux. mysql unable to write into /tmp since tmp security context was changed. Thanks for your tips. – webminal.org Mar 18 '11 at 13:51

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.

  • I checked with my friend- we made one change provided permission to a new user on newly created table.-Grant select, update, modify on DB.remap for efg; How does that turn-off/disable innodb? – webminal.org Mar 18 '11 at 11:27
  • What about output of 'SHOW PLUGINS' and 'SHOW ENGINES' commands? – rvs Mar 18 '11 at 12:30

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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.