mysql> create table mytable like oritable;   #将原表复制一份成新表mytable
mysql> alter table mytable engine=InnoDB;  #将新表的引擎修改成innodb
mysql> inset into mytable select * from oritable  #将原数据插入到新表中

当数据量大的j时候可以增加事物回滚.

START TRANSACTION;
mysql> inset into mytable select * from oritable  #将原数据插入到新表中
COMMIT;