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

Nick57

Well-Known Member
Jul 19, 2005
102
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,361
64
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