How to convert all MyISAM tables to InnoDB in a MySQL Database
To change multiple tables from the MyISAM storage engine to InnoDB, run SELECT CONCAT... to generate the conversion commands, then run the resulting commands…
EXPLORE THE TOPIC
Storage engine.
2 articles on this topic
How to find all tables use particular storage engine on MySQL
MySQL supports various table engines, including MyISAM, InnoDB, MEMORY, and NDB. Finding which engine a table uses may seem complicated, but it is straightforward…