MyISAM --> InnoDB

[LiveG]

Hello,

I have got this error in the support center.

"InnoDB database tables typically perform more efficiently and reliably than other database engines such as MyISAM on most modern hosts when configured correctly. It is strongly encouraged to ensure all of your database tables are using the InnoDB storage engine and that your hosting provider has configured MySQL for InnoDB use. "

I have indeed seen In the ACP SQL Toolbox that I have several MyISAM  engines running for some tables,

What is the safest what to the migration? Can I do it easily via the ACP or involve our system guy?

Edited July 21, 2023 by LiveG

[Marc]

This is something done on your MySQL instance, not within your admin CP. If you are unsure, you should indeed contact your hosting company to assist you

[LiveG]

Ok,

Thank you. does this action could be a show stopper for my form?

[Marc]

Only really if it causes you issues. But in our experience, at some point it will

[Miss_B]

You can also convert it yourself should your host will not help you with that. Have a look at this article. 

https://www.techandme.se/convert-myisam-to-innodb/

Don't forget to make first a backup of the database before the conversion. 

[LiveG]

Thak you! @Miss_B @Marc Stridgen

[alistairgd66]

I converted them all to innoDB but I am still getting the warning message in the ACP. How can I troubleshoot this?

[DawPi]

For 99% there are MyISAM tables still. Double check all of them. For example via PhpMyAdmin.

[Marc]

If you still have that message, then you do indeed still have tables that are not INNODB somewhere

[alistairgd66]

Screenshot below of all tables.

I'm assuming other tables in the dbase used by other apps are irrelevant. And I assume all forum tables are prefixed the same ie ibf_

 

[teraßyte]

The tables look fine.

Just to double-check, is the warning message in ACP the same as before? The warning might have changed from the tables being MyISAM to the InnoDB tables using a COMPACT row format instead of DYNAMIC.

[alistairgd66]

Thanks but I fixed the Compacts first, all clear.

[Marc]

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you.