Server Administration & Management

How to enable InnoDB engine in MySQL

1) Check whether InnoDB is enabled on the server. To check login to shell as root and go to mysql prompt.

i) #mysql

ii) mysql> show engines;

Search for InnoDB and check whether it is Enabled or Disabled.

iii) mysql> quit

2) Now if it is disabled and to make it enabled on the server edit /etc/my.cnf file and comment skip-innodb line as bellow.

i) nano /etc/my.cnf

ii) Restart mysql service.

# /etc/init.d/mysql restart

February 9, 2011 - Posted by | MySQL | ,


  1. I’ve been hunting for exactly this article. Even though I was intending to locate this content I’m definitely impressed that your article was so easy to locate and just how it correctly in comparison to my own experience.

    Comment by filtered water | June 15, 2011 | Reply

  2. I notice that your particular knowing of this topic is strong and comprehensive. What a goody to discover someone writing that not merely boasts knowledge but in addition a chance to communicate by means of easy to picture and remember info-bytes. Write more!

    Comment by great water filters | June 16, 2011 | Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: