wpsnoop: Origins of the WordPress database table "bb_profiles"

WordPress is comprised of many database tables and many plugins and themes operate without needing to create new tables. When asked where did the table bb_profiles come from?

This page provides some information on the bb_profiles table and a list of plugins and themes where it may have originally come from.

Total Uses

Clean Installs

1/2

Orphaned / Zombie Tables

Can the bb_profiles table be deleted safely?

Maybe. It depends on your situation: If you are sure that you no longer use the plugin or theme that created the bb_profiles table you can certainly delete it with phpMyAdmin BUT we would suggest renaming the table to something else like old-bb_profiles and make sure your WordPress installation still works :)
Assuming everything seems ok after renaming the table you can safely DROP old-bb_profiles and carry on.
Remember that backups are your friend so make them often and if necessary consider hiring a professional to assist you.

Plugins and Themes that create a database table called "bb_profiles"

A database table called bb_profiles is created by 2 different WordPress plugins/themes:

Name	Type
BuddyPress Profiles Manager	Plugin
Elvito BP	Plugin

This is potentially a serious conflict which could cause plugins or themes to produce strange and bizzarre behavior, errors, issues saving or loading settings who knows really. Or nothing might happen at all - it is entirely possible that these tables all store basically the same kind of data and that the plugins are intelligent enough to cooperate on that data without conflicting.

Plugins and Themes that cleanly remove a database table named "bb_profiles"

The table *should* remove itself when the following plugin/theme is properly uninstalled via the WordPress admin interface or using WP-CLI.

Name	Type
Elvito BP	Plugin

MySQL orphan or zombie database table named "bb_profiles" info

A database table called "bb_profiles" seems to persist and is not cleanly removed by the following plugin/theme:

Name	Type
BuddyPress Profiles Manager	Plugin	Get help with BuddyPress Profiles Manager cleanup or errors

Orphaned or Zombie tables can take up space in MySQL, add to your server load and could present conflicts with other plugins or themes. It is recommended that you invest a bit of effort removing the "zombie" database tables if you have no plans to use that plugin or theme in future. Remember to make backups.

Normal WordPress Database Tables

The following are commmonly WordPress database tables found in all standard installations

wp_posts
wp_postmeta
wp_options
wp_users
wp_usermeta
wp_term_taxonomy
wp_terms
wp_term_relationships

Many of these tables are related to each other, for a very complete and informative post explaining in great detail the inner workings of the WordPress table structure check out the wordpress codex database description