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;
![](https://docs.mightybox.io/wp-content/uploads/2023/08/image-90-1024x419.png)
This will provide you with a list of SQL statements to execute, such as:
![](https://docs.mightybox.io/wp-content/uploads/2023/08/image-91.png)
Copy those statements, hit the “SQL” tab again, and paste/run the queries to update the engine type on the selected tables.