How to enable InnoDB engine in MySql ?

Table of Contents

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

i) root@server [~]#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
#skip-innodb

ii) Restart mysql service.
/etc/init.d/mysql restart

Thanks , How to enable InnoDB engine in MySql ?, Hostripples Web Hosting


How to enable InnoDB engine in MySql ?, Hostripples Web Hosting
HR-ADMIN