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

Nick57

• November 30, 2013 08:41

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

  • December 01, 2013 03:22

  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

  0
• 

  Nick57

  • December 01, 2013 07:39

  Thanks, works perfect.

  0
• 

  cPanelMichael

  • December 02, 2013 14:36

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

  0

Please sign in to leave a comment.