1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Guide to convert from MyISAM to InnoDB

Use to convert from MyISAM to InnoDB when host did not have InnoDB configured at initial install

  1. Tracy Perry
    Compatible XF Versions:
    • 1.4
    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...
    You do not have permission to view the full content of this resource.
    maszd, Marcus, DeltaHF and 2 others like this.

Recent Reviews

  1. DeltaHF
    DeltaHF
    5/5,
    Very timely for me, as I was just looking for a guide on this to make sure I converted the correct tables. This saves me from having to look up the XF 'create table' calls in the install script. Thanks!
    1. Tracy Perry
      Author's Response
      I'm glad you found it useful. The discussion area has some more in depth that you can do. This was just to get back to the normal installation setup.