ndzlogo-1-1
Loading ...

INDIA – HEADQUARTERS

INDIA

UNITED STATES

CANADA

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.