4 Steps for changing your WordPress database table prefix

change_wp_prefix.txt

1. Change table prefix in wp-config.php

2. Change table names. Script below:

RENAME table `wp_commentmeta` TO `new_commentmeta`;
RENAME table `wp_comments` TO `new_comments`;
RENAME table `wp_links` TO `new_links`;
RENAME table `wp_options` TO `new_options`;
RENAME table `wp_postmeta` TO `new_postmeta`;
RENAME table `wp_posts` TO `new_posts`;
RENAME table `wp_terms` TO `new_terms`;
RENAME table `wp_termmeta` TO `new_termmeta`;
RENAME table `wp_term_relationships` TO `new_term_relationships`;
RENAME table `wp_term_taxonomy` TO `new_term_taxonomy`;
RENAME table `wp_usermeta` TO `new_usermeta`;
RENAME table `wp_users` TO `new_users`;

3. Search options table for fields with old prefix:

SELECT * FROM `new_options` WHERE `option_name` LIKE '%wp_%'

4. Same search, but in the user meta table:

SELECT * FROM `new_usermeta` WHERE `meta_key` LIKE '%wp_%'