To replace database engine on all tables for the given database. this script will prepare all the command that need to be run.
SET @DATABASE_NAME = '_database_that_you_like_to_change_';
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;Just copy result and run as SQL script
By
1 thought on “Change all tables to InnoDB in MySQL”
Rav
Great once @Pat