Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
CiberBob Posted December 9, 2021 Posted December 9, 2021 Hi, Do you know how to convert all tables from MyISAM to InnoDB? I know I can issue alter table individually to change table storage from MyISAM to InnoDB. I'm wondering if there is a way to quickly change them all to InnoDB? thank you very much Best regards
Marc Posted December 10, 2021 Posted December 10, 2021 This is something you would be best to discuss with your hosting company. There are ways you can do so by creating your own sql scripts, as seen here, but this is outside the scope of our support and not something I would advise undertaking at all if you are unsure what you are doing https://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb CiberBob 1
Recommended Posts