1、进入数据库
2、SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = '数据库名' AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC into outfile '/var/lib/mysql/输出文件名'; #找到引擎为myisam的表
3、mysql 数据库名 < /var/lib/mysql/输出文件名 #更改表引擎