WordPress Table Prefix

OK, how would you change table prefix in productive site?

I've updated my original answer with info to help you change the prefix for an existing site.

Good, I haven’t missed anything by your research. I’m going to do it now. Thanks seanf.

I did login phpMyAdmin.

I can change all WordPress table prefixes but why can’t I changed some parts of BuddyPress table prefixes:

I can change this:

xxxxxxxxx_bb_forums
xxxxxxxxx_bb_meta
xxxxxxxxx_bb_posts
xxxxxxxxx_bb_terms
xxxxxxxxx_bb_term_relationships
xxxxxxxxx_bb_term_taxonomy
xxxxxxxxx_bb_topics

Why can’t I change this?

wp_bp_activity
wp_bp_activity_meta
wp_bp_friends
wp_bp_groups
wp_bp_groups_groupmeta
wp_bp_groups_members
wp_bp_messages_messages
wp_bp_messages_notices
wp_bp_messages_recipients
wp_bp_notifications
wp_bp_xprofile_data
wp_bp_xprofile_fields
wp_bp_xprofile_groups

When I run SQL query/queries on database myWPdatabase:

Rename table wp_bb_activity to xxxxxxxxx_bb_activity

I get this:

1017 - Can't find file: './myWPdatabase/wp_bb_activity.frm' (errno: 2)

Thanks, Mikey3D

Try using ALTER TABLE instead, for example:

ALTER TABLE wp_bb_activity RENAME xxxxxxxxx_bb_activity;