Changing WordPress database table prefix

gistfile1.txt

After renaming table names:

1.
UPDATE {$new_prefix}options SET option_name = "{$new_prefix}user_roles" WHERE option_name = "{$old_prefix}user_roles";

2.
UPDATE {$new_prefix}usermeta SET meta_key = "{$new_prefix}capabilities" WHERE meta_key = "{$old_prefix}capabilities";

3.
UPDATE {$new_prefix}usermeta SET meta_key = "{$new_prefix}user_level" WHERE meta_key = "{$old_prefix}user_level";