myisam 表 转换为 innodb 表_MySQL

从InnoDB引擎转换成MyISAM引擎，看完本文，你应该懂得如何操作以把MyISAM引擎转换成InnoDB引擎了（请确保InnoDB开启，MySQL命令行下SHOW ENGINES命令查看）。

mysql> ALTER TABLE  boblog_history   ENGINE=InnoDB;

Query OK, 2808 rows affected (0.76 sec)

Records: 2808  Duplicates: 0  Warnings: 0

ALTER TABLE  boblog_blogs     ENGINE=InnoDB;

ALTER TABLE  boblog_calendar  ENGINE=InnoDB;

ALTER TABLE  boblog_categoriesENGINE=InnoDB;

ALTER TABLE  boblog_counter   ENGINE=InnoDB;

ALTER TABLE  boblog_forbidden ENGINE=InnoDB;

ALTER TABLE  boblog_history   ENGINE=InnoDB;

ALTER TABLE  boblog_linkgroup ENGINE=InnoDB;

ALTER TABLE  boblog_links     ENGINE=InnoDB;

ALTER TABLE  boblog_maxrec    ENGINE=InnoDB;

ALTER TABLE  boblog_messages  ENGINE=InnoDB;

ALTER TABLE  boblog_mods      ENGINE=InnoDB;

ALTER TABLE  boblog_pages     ENGINE=InnoDB;

ALTER TABLE  boblog_plugins   ENGINE=InnoDB;

ALTER TABLE  boblog_replies   ENGINE=InnoDB;

ALTER TABLE  boblog_tags      ENGINE=InnoDB;

ALTER TABLE  boblog_upload    ENGINE=InnoDB;

ALTER TABLE  boblog_user      ENGINE=InnoDB;

来自：http://www.samhere.net/mysql_innodb_to_myisam.html