Change Table Storage Engine
by Kyle on · Posted in MySQL
Change a table's storage engine, or table type, from MyISAM to InnoDB:
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' ENGINE=InnoDB;') FROM `information_schema.tables` WHERE ENGINE = 'MYISAM';
