Changing default storage engine in MySQL

The setting in my.cnf to change the default storage engine to InnoDB

[2010-09-15]

I always forget this! So here it is:

# /etc/mysql/my.cnf
# ...
[mysqld]
default-storage_engine = InnoDB

And then restart MySQL.

☙

• index
• Linux

My e-mail address is "you (at) norman.hooper.name".
	This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.