Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 9, 20213 yr 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
December 10, 20213 yr Community Expert 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