If you know something about databases, and have access to the back end SQL database (most likely through Cpanel/phpMyAdmin, you can see the structure of the database, including the columns (fields) and their attributes. Knowing this, you can export an Access query into an Excel file with the same fields and attributes as the BuddyPress SQL table, save the Excel file as a csv file, then import the csv file through phpMyAdmin’s import function.
I’ve done this several times. I don’t use BuddyPress, so I don’t have the table structure, but you can design all your query exports to Excel to match the SQL structure of the tables in question.
Related Posts:
- Multiple developers / editors working on a site in progress
- How many users can WordPress handle?
- How to track user progress?
- Performance tips for a large user base [closed]
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- Efficiency on displaying random authors based on large database
- How to update BuddyPress xprofile fields programmatically? [closed]
- Extend the wp_users table
- How to use user table of a different database for WordPress users?
- Subscribers to posts
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Select Multiple meta_value from WP DB; Single Query
- Getting all the users who have author privilege
- Does WordPress always create unique passwords?
- In what part of the WordPress core does the users table and usermeta table get joined?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Modify Database in Multi-Site wp_usermeta table
- Change WordPress prefix for only one table?
- wp_get_current_user always returns 0 continued
- Is there a smart way to obtain a list of only some selected user meta data?
- How can i customize the export personal data file?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Import users from old WP site to new one
- How to get membershiplevel from WordPress Database?
- How to Access wp_usermeta Data Immediately After a New User is Created
- Logins from WP users table use on another page
- 2 WordPress sites with 2 databases but sharing the same users
- Convert user passwords to MD5?
- Does WordPress store the username as a primary key in the database?
- Is there a way to execute a php script outside WordPress?
- multiple wordpress installation with shared usertable on an different database
- Best practice to import user base (subscribers) from one website to another?
- Share users across multiple sites on same database, but with different domains
- Users table missing from Database [closed]
- Some weird users in database
- How to delete a particular row in a database table
- Recovering the table wp_usermeta from users
- Regenerate user_nicename column
- Buddypress avatar image in database [closed]
- Storing user submitted forms [closed]
- WordPress where clauses in db select
- wp_insert_user not creating account correctly when ID is manually set
- Select From wpdb – Author/User Directory page
- Can’t log into wordpress site – I have made a new user and still cant access
- Need help with creating a searchable user data by name or specific number like ID
- Migrate Users From laravel to wordpress
- Display user data in numbered list
- User input to database
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- Change user_nickname for author page link
- how restrict user to give star ratings once for a post?
- create a table using user meta custom data
- How to get the id of recently registered user from database?
- How to save dropdown slection by a user in the DB
- How to get specific table by current user login
- update multiple user meta field based on another meta field
- Hash user emails in database?
- Changed meta_key value in structures, now dashboard shows zero users
- What WordPress file is saving new users to database
- Get id from database
- WordPress sync with phpbb
- import (migration) user database to wp-users
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- WP Multisite Users Not Linking
- How SID is different from Service name in Oracle tnsnames.ora
- What is a relation in database terminology?
- Why WordPress choose data serialization over json_encode?
- Reset Post IDs to less than 64bit integer
- Does WordPress use the InnoDB engine for MySQL by default?
- $wpdb->prepare() warning in WordPress 3.5
- Best way to import users, post and categories from an external database
- wp_options is GB in size
- Can’t update database after wordpress update from 3.8.1 to 4.4.1
- Add Admin User via SQL
- How can I create a Bible search engine via WordPress? [closed]
- Subscribe to author?
- Error establishing a database connection; After importing DB & Theme
- Auto login subdomain from main domain on single sites with different DB
- Change the default data installed when setting up WordPress
- $wpdb->get_var – What value is returned when zero records are found?
- SymmetricDS in dev + prod workflow?
- Fixing YARPP plugin FULLTEXT MySQL indexing
- Counting post and changing roles in mysql database. Query not code
- wpdb Insert unknown post data dynamic foreach loop
- How do I use a database in a custom theme?
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- How do you enable scripts on a WordPress installation in Softaculous?
- How to rerieve comments and their replies from DB
- Inserting data with Geometry field
- Export only a part of the database for migration
- Why am I being prompted to reinstall wordpress?
- database error WordPress move from one hosting to other
- Same DB for live and dev versions
- After renaming MySQL database, I can no longer access my Blog page
- execute custom function on database connection error
- not saving post in wp_post wordpress database table
- How to add data from wordpress tables to new database tables you have created
- How to back-up a database on IIS
- Where are database files of a WordPress website?