Convert all tables from MyISAM to InnoDB

[CiberBob]

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]

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]

Thank you very much

Best regards