Linux Knowledgebase Portal

Posted on: May 20, 2011


how to set default storage engine

If you are looking for how to set default storage engine on Linux no matter the LAMPP setup read below.

If you are running Xampp (Lampp on Linux --> apachefriends.org) all you need to do is to edit /opt/lampp/etc/my.cnf and add after [mysqld] the following line:

default-storage-engine=InnoDB

If you want to use MyISAM just alter the line:

default-storage-engine=MyISAM

and then restart mysql