1,语句修改,更改表引擎的语句为:alert table mytable engine=InnoDB;这种非常耗资源
2,导入和导出生成脚本,然后更改脚本的文件的引擎语句
3,创建和查询语句:
Create table innodb_table like myisam_table;
alert table innodb_table ENGIN=InnoDB
innsert into innodb_table select * from myisam_table.
数据量太大的话可以分批复制, innsert into innodb_table select * from myisam_table where id between x and y.