up vote 1 down vote favorite
share [g+] share [fb]

When I run the query "Show Engines" on this particular Linux host, it shows that the InnoDB storage engine is Disabled. Other storage engines (like MyISAM) are showing enabled.

What steps would I need to take to install/enable the InnoDB storage engine (even at a high level)? Would the procedures be different for different flavors of linux?

link|improve this question
feedback

2 Answers

up vote 2 down vote accepted

InnoDB can be enabled/disabled in your my.cnf (MySQL config), but, in order to use it MySQL has to have been compiled with InnoDB support.

link|improve this answer
feedback
up vote 0 down vote

most likely it isn't disabled at compile time (as it normally isn't) but failed to start up. check mysql's error log. Probably couldn't write the needed ibdata files..

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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