How to enable INNODB in mysql

mysql sql transactions innodb
Shahid Karimi picture Shahid Karimi · Jan 21, 2011 · Viewed 89.4k times · Source

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

Mchl picture Mchl · Jan 21, 2011

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

http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#option_mysqld_innodb

Or you can load an InnoDB plugin during runtime:

http://dev.mysql.com/doc/refman/5.1/en/replacing-builtin-innodb.html

Related questions

MySQL : transaction within a stored procedure

The basic structure of my stored procedure is, BEGIN .. Declare statements .. START TRANSACTION; .. Query 1 .. .. Query 2 .. .. Query 3 .. COMMIT; END MySQL version: 5.1.61-0ubuntu0.11.10.1-log Currently, if 'query 2' fails, result of 'query 1' is committed. How can I rollback the transaction …

Read More
Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)

I am reading up on transactions in MySQL and am not sure whether I have grasped something specific correctly, and I want to be sure I understood that correctly, so here goes. I know what a transaction is supposed to …

Read More
When to use SELECT ... FOR UPDATE?

Please help me understand the use-case behind SELECT ... FOR UPDATE. Question 1: Is the following a good example of when SELECT ... FOR UPDATE should be used? Given: rooms[id] tags[id, name] room_tags[room_id, tag_id] room_id and …

Read More