How to force mysql v.5.5.32 to create MyISAM tables instead of InnoDB?

[Nick57]

I have upgraded to this latest version of MySQL 5.5.32, but it standard creates InnoDB based tables and to be compatible with some software I run I would like it to create a new DB with MyISAM tables.

How to do this?

 

[mtindor]

Put this in your /etc/my.cnf -- replacing any pre-existing one that might be setting InnoDB as default

default-storage-engine=MyISAM

Then do a /scripts/restartsrv_mysql
Mike

 

[Nick57]

Thanks, works perfect.

 

[cPanelMichael]

Hello

I am happy to hear the solution provided to you was helpful. I am marking this thread as [Resolved].

Thank you.