Skip to content

Instantly share code, notes, and snippets.

@wuliupo
Created January 18, 2017 11:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wuliupo/5c9c44a4132677f195e407ee04165dcd to your computer and use it in GitHub Desktop.
Save wuliupo/5c9c44a4132677f195e407ee04165dcd to your computer and use it in GitHub Desktop.
update wordpress database to utf8
ALTER TABLE `wp_commentmeta` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_comments` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_layerslider` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_links` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_options` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_post2tag` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_postmeta` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_posts` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_revslider_css` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_revslider_layer_animations` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_revslider_settings` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_revslider_sliders` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_revslider_slides` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_tags` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_tag_synonyms` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_termmeta` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_terms` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_term_relationships` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_term_taxonomy` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_usermeta` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ALTER TABLE `wp_users` ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment