Jump to content

Convert all tables from MyISAM to InnoDB


Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...