I would appreciate if anyone could help me of what's the proper command in MySQL to query all database for having "MyISAM" engine. I need to convert all DB & tables from MyISAM to InnoDB.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Below is the Query to find all the tables which have
Above Query will list all the tables having
For how to convert your existing MyISAM tables to InnoDB
Below is the Query that will Return ALTER Statements to convert existing
You Can execute these statements to convert engines.