Softaculous upgrade

Administration
1

Did the upgrade today on Softaculous. The only thing I don’t know how to handle is changing to InnoDB. Is this something (cPanel) users can do by themselves, or do they need to ask their hosting provider?

2

OK, I’ve figured out it can be accomplished as a MySQL query in phpMyAdmin, like:
ALTER TABLE * ENGINE = InnoDB;
(Except that * doesn’t work, do I have to do it for every one of the fiftysomething tables, or is there an easier way?

3

(Sorry, more like close to two hundred tables…)

4

If you go into Gibbon, under Admin > System Admin > Update, there is a section that handles this conversion. First you’ll have to run any outstanding data updates (which you should do as soon as you update to avoid issues). Let us know if this works! Ross.

PS, yes, Gibbon has MANY tables!

5

Thanks for the speedy reply! For some reason it never occurred to me to manually refresh this tab in my browser, so I only just now clicked on the update link where you said. At the bottom it then said: “All of your tables are set to InnoDB. Well done!”, so it seems like I’m set!

6

Thanks for the speedy reply! For some reason it never occurred to me to manually refresh this tab in my browser, so I only just now clicked on the update link where you said. At the bottom it then said: “All of your tables are set to InnoDB. Well done!”, so it seems like I’m set!

7

If I may give some more feedback on that, I thought I’d recheck the System Admin page, and clicking on the Updates link brought me to the exact same place, where it says at the bottom (in orange): “Your current default database engine is: MyISAM. It is advised that you change your server config so that your default storage engine is set to InnoDB.” and then under that (in green): “All of your tables are set to InnoDB. Well done!”.

That is confusing. If the page can see that the tables are set to InnoDB, it would be better if the orange message is not displayed.

Unless I misunderstand this, and my TABLES are set to InnoDB but my ENGINE is MyISAM. If this is the case, how do I change my MySQL engine to InnoDB?

8

What you should see, when everything has worked, is the following:

It sounds like your assessment is right, your database engine is not set. Gibbon can’t do this for you, but you can do it via your MySQL config:

https://www.liquidweb.com/kb/mysql-performance-myisam-vs-innodb/

Let us know how you get on.