Skip to content

Instantly share code, notes, and snippets.

@henrytriplette

henrytriplette/table_options.md

Created September 12, 2019 09:31
Show Gist options
  • Save henrytriplette/c9ba15f9f1fc8d1c9fba630d568a4b13 to your computer and use it in GitHub Desktop.
Save henrytriplette/c9ba15f9f1fc8d1c9fba630d568a4b13 to your computer and use it in GitHub Desktop.
Download ZIP
Wordpress $table_options migration fix
Raw
table_options.md

RENAME tablewp_commentmetaTOmistrello_commentmeta; RENAME tablewp_commentsTOmistrello_comments; RENAME tablewp_linksTOmistrello_links; RENAME tablewp_optionsTOmistrello_options; RENAME tablewp_postmetaTOmistrello_postmeta; RENAME tablewp_postsTOmistrello_posts; RENAME tablewp_termsTOmistrello_terms; RENAME tablewp_termmetaTOmistrello_termmeta; RENAME tablewp_term_relationshipsTOmistrello_term_relationships; RENAME tablewp_term_taxonomyTOmistrello_term_taxonomy; RENAME tablewp_usermetaTOmistrello_usermeta; RENAME tablewp_usersTOmistrello_users;

SELECT * FROM mistrello_options WHERE option_name LIKE '%wp_%'; SELECT * FROM mistrello_usermeta WHERE meta_key LIKE '%wp_%';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment