wordpress 數據庫引擎轉換

mysql存儲引擎 InnoDB >MyISAM

ALTER TABLE wp_commentmeta ENGINE=MYISAM;
ALTER TABLE wp_comments ENGINE=MYISAM;
ALTER TABLE wp_links ENGINE=MYISAM;
ALTER TABLE wp_options ENGINE=MYISAM;
ALTER TABLE wp_postmeta ENGINE=MYISAM;
ALTER TABLE wp_posts ENGINE=MYISAM;
ALTER TABLE wp_terms ENGINE=MYISAM;
ALTER TABLE wp_term_relationships ENGINE=MYISAM;
ALTER TABLE wp_term_taxonomy ENGINE=MYISAM;
ALTER TABLE wp_usermeta ENGINE=MYISAM;
ALTER TABLE wp_users ENGINE=MYISAM;

mysql存儲引擎 MyISAM > InnoDB

ALTER TABLE wp_commentmeta ENGINE=INNODB;
ALTER TABLE wp_comments ENGINE=INNODB;
ALTER TABLE wp_links ENGINE=INNODB;
ALTER TABLE wp_options ENGINE=INNODB;
ALTER TABLE wp_postmeta ENGINE=INNODB;
ALTER TABLE wp_posts ENGINE=INNODB;
ALTER TABLE wp_terms ENGINE=INNODB;
ALTER TABLE wp_term_relationships ENGINE=INNODB;
ALTER TABLE wp_term_taxonomy ENGINE=INNODB;
ALTER TABLE wp_usermeta ENGINE=INNODB;
ALTER TABLE wp_users ENGINE=INNODB;