Jump to content

Featured Replies

Posted

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

  • 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

  • Author

Thank you very much

Best regards

Recently Browsing 0

  • No registered users viewing this page.