Skip to content

Instantly share code, notes, and snippets.

@jennimckinnon
Created August 24, 2016 21:31
Show Gist options
  • Save jennimckinnon/4ec9b1394631e9412954dcfbf2f95bed to your computer and use it in GitHub Desktop.
Save jennimckinnon/4ec9b1394631e9412954dcfbf2f95bed to your computer and use it in GitHub Desktop.
RENAME table `wp_commentmeta` TO `newprefix_commentmeta`;
RENAME table `wp_comments` TO `newprefix_comments`;
RENAME table `wp_links` TO `newprefix_links`;
RENAME table `wp_options` TO `newprefix_options`;
RENAME table `wp_postmeta` TO `newprefix_postmeta`;
RENAME table `wp_posts` TO `newprefix_posts`;
RENAME table `wp_terms` TO `newprefix_terms`;
RENAME table `wp_term_relationships` TO `newprefix_term_relationships`;
RENAME table `wp_term_taxonomy` TO `newprefix_term_taxonomy`;
RENAME table `wp_usermeta` TO `newprefix_usermeta`;
RENAME table `wp_users` TO `newprefix_users`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment