Topic on Project:Support desk

Jump to navigation Jump to search

Converting from MyISAM to InnoDB

4
Kaleb Grace (talkcontribs)

When I installed my wiki, I didn't have InnoDB enabled and it created all the tables with MyISAM. I've since enabled InnoDB. Which process should I go through to convert my wiki over to InnoDB? Which tables should I convert, and are there any settings I need to change in the wiki/config?

Thanks in advance! --Kaleb Grace (talk) 10:16, 23 June 2012 (UTC)

88.130.96.228 (talkcontribs)

There is no special process to go through, just change the engine and that's it.

You can do this for all tables, but not for "searchindex", because there the fulltext search feature of MyISAM is needed (which InnoDB does not yet support).

You can use phpmyadmin, if you that installed. But take note that changing the engine depending on the size of the tables and the power of your server may take quite some time. This could lead to a PHP timeout in the middle of the process, which could leave your table in inconsistent state.

Another option is to do an ALTER table ENGINE=InnoDB; on the command line, if you have command line access. There restrictions coming from PHP do not apply.

Kaleb Grace (talkcontribs)

Perfect! this is exactly the information I needed. Thank you so much! --Kaleb Grace (talk) 21:34, 23 June 2012 (UTC)

Reply to "Converting from MyISAM to InnoDB"