latest stable versions: v150827 (changelog)

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

Mysql access to members list

Home Forums Community Forum Mysql access to members list

This topic contains 1 reply, has 2 voices. Last updated by  Bruce 3 years, 11 months ago.

Topic Author Topic
Posted: Monday Jan 21st, 2013 at 2:44 pm #38608
Aymeric B
Username: AymericB87

Hi,
I need my s2members list of users to be copied automatically to an other server every 24h. I though of using a mysql automatic copy but I can’t find the tables used by s2members. Where are they please ?

List Of Topic Replies

Viewing 1 replies (of 1 total)
Author Replies
Author Replies
Posted: Wednesday Jan 23rd, 2013 at 3:51 am #39130
Bruce
Username: Bruce
Staff Member

Thanks for your inquiry.

s2Member does not create any new SQL tables in your database, but instead uses the default WordPress tables wp_users and wp_usermeta to store user information.

If you’d like to export user data via Cron Job every 24 hours, you would need to get the information from the wp_users and wp_usermeta table. Some specific rows that s2Member puts into the usermeta table are:

wp_s2member_paid_registration_times
wp_s2member_subscr_gateway
wp_s2member_login_counter
wp_s2member_registration_ip
s2member_file_download_access_log

Please let us know if you have any more questions / concerns.

Viewing 1 replies (of 1 total)

This topic is closed to new replies. Topics with no replies for 2 weeks are closed automatically.

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

Contacting s2Member: Please use our Support Center for bug reports, pre-sale questions & technical assistance.