Enable Innodb in cPanel server
on
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
OR
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 default-table-type=innodb
Thanks.
