SQL replace WordPress table prefix

SQL 47

1. OPEN your DATABASE IN PhpMyAdmin.
2. Click ON the DATABASE name IN the menu TO the LEFT TO unfold ALL TABLES.
3. SELECT ALL TABLES that START WITH wp_; you should have 12 IN total.
4. Click WITH selected TO OPEN the drop-down menu AND SELECT REPLACE TABLE prefix.
5. TYPE IN wp_ IN the From-FIELD, AND the NEW name IN the To-FIELD, IN this example, david_.
6. Click Continue TO make the CHANGE.
# Run 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';

Recent Pastes

Raw Paste