从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
