Skip to content

Instantly share code, notes, and snippets.

@loorlab

loorlab/query_change_table_prefix_SQL_WP.sql

Created May 9, 2024 17:49
Show Gist options
  • Save loorlab/d8e7700ee1517f55cbf5244c0fa7d360 to your computer and use it in GitHub Desktop.
Save loorlab/d8e7700ee1517f55cbf5244c0fa7d360 to your computer and use it in GitHub Desktop.
Download ZIP
Query WP - SQL - Change the table prefix for WordPress
Raw
query_change_table_prefix_SQL_WP.sql
update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_capabilities' where meta_key = 'OLDPREFIX_capabilities';
update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_user_level' where meta_key = 'OLDPREFIX_user_level';
update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_autosave_draft_ids' where meta_key = 'OLDPREFIX_autosave_draft_ids';
update NEWPREFIX_options set option_name = 'NEWPREFIX_user_roles' where option_name = 'OLDPREFIX_user_roles';
@loorlab
Copy link
Author

loorlab commented May 9, 2024

vía https://help.one.com/hc/en-us/articles/360002107438-Change-the-table-prefix-for-WordPress#step-2

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