Resource icon

Guide to convert from MyISAM to InnoDB

Admin

Administrator
Staff member
Joined
Sep 28, 2017
Messages
1,529
Reactions
110
Points
63
Admin submitted a new resource:

Guide to convert from MyISAM to InnoDB - Guide to convert from MyISAM to InnoDB

So, you've found that you have and imported your DB into a new host that had their default engine as MyISAM and they didn't have InnoDB configured for mySQL.

First, let's preface this with the warning of BEFORE YOU RUN ANY OF THESE, MAKE SURE YOU HAVE BACKED UP YOU DATABASE!

This should work on any of the 5.x series of mySQL server, but this was done on a Percona 5.6 release and confirmed to work (as I had forgotten to enable InnoDB as an engine and assign it as a default on...
Read more about this resource...