myisam表转换为innodb表_MySQL

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

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com