Mysql: how to change default storage engine

If you want to change default storage engine for mysql (currently set to MyISAM on my version), simply set the following option into /etc/mysql/my.cnf:

default-storage-engine = INNODB

Don’t forget to reload mysql server (/etc/init.d/mysql restart)

sources

Post a Comment

Your email is never published nor shared. You're allow to say what you want...