How to enable Innodb as default storage engine ?

Solution :

Just edit your /etc/my.cnf file and look for this line:

skip-innodb

If such an entry exists, remove or comment out the entry

#skip-innodb

Next make the storage_engine variable to Innodb by adding following under [mysqld] section.

default-storage_engine = InnoDB
save the file, and restart mysql:

Restart mysql service

This entry was posted on Thursday, November 20th, 2008 at 1:08 pm and is filed under Plesk, WHM/cPanel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.