Profile data is stored in the following tables:
wp_bp_xprofile_groups – The profile groups
wp_bp_xprofile_fields – The fields, what type they are, the name etc.
wp_bp_xprofile_data – The data for each user for specific fields
Avatars are stored in:
wp_usermeta – with the meta_keys:
‘bp_core_avatar_v1’ – the URL to the avatar thumbnail
‘bp_core_avatar_v1_path’ – the filesystem path to the thumbnail
‘bp_core_avatar_v2’ – same as v1 but the full size image
‘bp_core_avatar_v2_path’ – same as v1 but the full size image