转换(InnoDb->MyISAM)
CREATE TABLE T_MyISAM LIKE T_InnoDB;
ALTER TABLE T_MyISAM ENGINE = INNODB;
INSERT INTO T_MyISAM SELECT * FROM T_InnoDB;
数据少的时候可以采用上述方式,数据太多可以采用事务来处理
START TRANSACTION;
INSERT INTO T_InnoDB SELECT * FROM T_MyISAM WHERE id BETWEEN x AND y;
COMMIT;