As shown in video 6 & 7, you should try the easy method first using the plugin discussed in the video.

If that fails you need to replace both your wp-config.php file and the database files with the backups you did just before trying the plugin method - again, as shown in the video.

Now step 1 of the manual method is to edit the wp-config.php file.

Step 2 is to use the following codes to change the database table prefix names: ** Replace the mynewprefix text with the NEW prefix name you have **

(if you have more tables than just these, simply add those table names to this list as shown in the video)

RENAME table `wp_commentmeta` TO `mynewprefix_commentmeta`;
RENAME table `wp_comments` TO `mynewprefix_comments`;
RENAME table `wp_links` TO `mynewprefix_links`;
RENAME table `wp_options` TO `mynewprefix_options`;
RENAME table `wp_postmeta` TO `mynewprefix_postmeta`;
RENAME table `wp_posts` TO `mynewprefix_posts`;
RENAME table `wp_terms` TO `mynewprefix_terms`;
RENAME table `wp_termmeta` TO `mynewprefix6_termmeta`;
RENAME table `wp_term_relationships` TO `mynewprefix_term_relationships`;
RENAME table `wp_term_taxonomy` TO `mynewprefix_term_taxonomy`;
RENAME table `wp_usermeta` TO `mynewprefix_usermeta`;
RENAME table `wp_users` TO `mynewprefix_users`;


- Use this format for all tables -
RENAME table `wp_sometablename` TO `mynewprefix_sometablename`;
replace mynewprefix with your new prefix name


Step 3 is to use this code as shown in the video to adjust the names in the options table: ** Replace the mynewprefix text with the NEW prefix name you have **


UPDATE `mynewprefix_options` SET `option_name` = 'mynewprefix_user_roles' WHERE `option_name` = 'wp_user_roles'


Step 4 (final) is to use this code as shown in the video to adjust the names in the usermeta table: ** Replace the mynewprefix text with the NEW prefix name you have **


UPDATE `mynewprefix_usermeta` SET `meta_key` = REPLACE( `meta_key`, 'wp_', 'mynewprefix_' )