Myisam table to innodb table _ MySQL

Myisam table to innodb table to convert from InnoDB engine to MyISAM engine. after reading this article, you should know how to convert MyISAM engine to InnoDB engine (please make sure InnoDB is enabled, mySQL command line show engines command view ).

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_mod 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;

From: http://www.samhere.net/mysql_innodb_to_myisam.html