How to enable Innodb as default storage engine
Thursday, November 20th, 2008How 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 