How do I convert database tables to InnoDB?
Open PHPMyAdmin, select your database, and choose the "SQL" tab. Then run the following command (replacing INSERT_DB_NAME_HERE with your database name):
SET @DATABASE_NAME = 'INSERT_DB_NAME_HERE'; SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC;
This will provide you with a list of SQL statements to execute, such as:
Copy those statements, hit the "SQL" tab again, and paste/run the queries to update the engine type on the selected tables.