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

Posted on: 20/05/2011








0 Comments
If you want to leave a comment please Login or Register