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

Nick57

Well-Known Member
Jul 19, 2005
103
0
166
cPanel Access Level
Root Administrator
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

Well-Known Member
Sep 14, 2004
1,416
80
178
inside a catfish
cPanel Access Level
Root Administrator
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
Hello :)

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

Thank you.