Changing the prefix of tables on a existing WordPress site

commands.sql

-- So you have an existing WP website with a prefix you need to change
-- We will need to do more than just updating the wp-config.php prefix.
-- There are row data that reference table names we'll need to update

-- Assuming we're already using the wp_ prefix and for example want to 
-- change to xyzwp_ we'll need to update the data within the tables

-- Update user meta references
UPDATE wp__usermeta 
SET meta_key = REPLACE(meta_key, 'wp_', 'xyzwp_') 
WHERE meta_key LIKE 'wp_%';

-- Update options
UPDATE wp__options 
SET option_name = REPLACE(option_name, 'wp_', 'xyzwp_') 
WHERE option_name LIKE 'wp_%';