stored in database

[Onica]

Anyone knows where the member types data is stored in the database? Trying to find where in the database member types are stored and matched to the user.

Any help?

[Varun Dubey]

Hi @onica-nl
Please take a look of following thread.

Member Types

Regards
Varun Dubey

[Onica]

Hey @vapvarun,

I read THE article but i’m not looking for a code. I need to know in which tabels in THE database this information is stored.

I can then export it.
I tried numerously plugins to expert user information And bp information. Member type doesn’t come up.

[Alyssa]

Hey Onica,

Members Types using WordPress Custom Post Type bmt-member-type and is being stored in the wp_posts table.

I hope this helps.

[Onica]

Hi @paresh

Thanks for pointing in the right direction.

I found the types but not te links to the user. Where in the tablea is stored that “jack” is a member type ‘student’ and “sophie” member type ‘client’

[Alyssa]

Howdy,

Ah, sorry. I misunderstood your original post.

BuddyPress register a private taxonomy bp_user_type so you’ll find the link between users and members types in wp_terms, wp_term_relationship, wp_term_taxonomy and wp_termmeta

PS: Member Types plugin lets you create and manage member types without having to code and an actual users and member types linking is being handled by the core BuddyPress Member Type API

Let me know if you have any questions.

[Onica]

Hi @paresh,

so kind of you to explain. I understand now where it is stored. We want to export something like the user id or email and the specific membertype that is assigned..

If I understand correctly then it means all the information is stored in pieces with in 4 tables. any help on how to export the information we need?

[Alyssa]

Hi there!

Not sure if this is helpful or just retelling what you already know:

https://buddypress.org/support/topic/export-users-and-xprofile-data/
https://buddypress.org/support/topic/export-users/

Cheers!