Martha James Martha James - 2 years ago 200
SQL Question

How to enable INNODB in mysql

When I execute a query in MySQL it returns an error saying that InnoDB is not enabled. When I clicked the storage engine, the InnoDB was disabled.

How do I enable InnoDB?

Answer Source

You need to enable it in my.cnf file, then restart your server:

Or you can load an InnoDB plugin during runtime:

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download