Changing the table prefix in an installed Wordpress. Otherwise an obvious task, but steps four and five can stump you.
For step five, the following SQL snippet may come in handy.
UPDATE new_prefix_usermeta SET meta_key = REPLACE(meta_key, "wp_", "new_prefix_");
There’s also a plugin available.
