Guide to convert from MyISAM to InnoDB

Unmaintained Guide to convert from MyISAM to InnoDB

Overview Reviews (2) Discussion
Compatible XF 1.x versions
  1. 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.
  • Like
Reactions: jumadil awal, ASap, maszd and 4 others
Author
TPerry
Views
1,442
First release
Last update

Ratings

5.00 star(s) 2 ratings
Join the discussion

More resources from TPerry

Share this resource

Latest reviews

NikC
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.
Upvote 0 Downvote
DeltaHF
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!
TPerry
TPerry
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.
Upvote 0 Downvote
Read more…
Back
Top Bottom