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 | , | 2 Comments