Enable Innodb in cPanel server

To Enable innodb in cpanel server♦ First check if Innodb is enabled or not.

# mysqladmin variables | grep have_innodb ( To check Innodb enabled or not )
 | have_innodb | No


 mysql> show engines;

♦ Edit the configuration file

# vi /etc/my.cnf
#skip-inndob ( comment the line to activate Innodb)
♦ Restart Mysql
# /etc/init.d/mysql restart

Set default storage engine as Innodb

Edit the configuration file and add Innodb as the default storage engine.

# vi /etc/my.cnf[mysqld]
 default-storage-engine = innodb



There are no revisions for this post.

Tags: , , ,

No comments yet.

Leave a Reply