生成修改的SQL
mysql> SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;') FROM information_schema.tables WHERE table_schema!="mysql" and table_schema!="information_schema" AND ENGINE="myisam" into outfile "/tmp/update.sql";
Query OK, 45 rows affected (0.01 sec)
然后执行生成的文件即可。