LinuxHelps.com

A blog for Linux Lovers.

Posted by sibu on May 24, 2009

How to change the storage engine to InnoDB?

Edit the /etc/my.cnf file and look for this line:

skip-innodb

and comment it out:

#skip-innodb

Add the following entry in the /etc/my.cnf file

default-storage_engine = InnoDB

Save the file, and restart mysql

/etc/rc.d/init.d/mysqld restart

You can use the following command to check the “storage engine” used in the server.

mysqladmin variables | grep storage_engine

You will see the storage engine as “InnoDB”.

# mysqladmin variables | grep storage_engine
| storage_engine | InnoDB

Add A Comment