• 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

Guide to convert from MyISAM to InnoDB

Compatible XF 1.x 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. Log in or register now.
Author
Tracy Perry
First release
Last update
Rating
5.00 star(s) 2 ratings

More resources from Tracy Perry

Latest reviews

Saved me a lot of time! I ran the alter for Posts and Thread tables separately via the command line due to their size on my 11m post forum, but converted all the other tables via phpmyadmin using this code.
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!
Tracy Perry
Tracy Perry
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.