export using phpmyadmin the following tables
WP_activity
WP__activity_meta
WP__groups
WP__groups_groupmeta
WP__groups_members
ALL 4 TABLES OF WP_xprofile
WP_users
WP_usermeta
now setup BP in a single site. it would create the above tables automatically (check this before you import the older DB back)
now in phpmyadmin of SINGLE SITE of your fresh install of BP DELETE the above tables first and then import the .sql file which you would have exported from your older multisite DB.
Thank you for the reply 🙂 Since you have suggested to export TABLES OF WP_xprofile, I believe I don’t need to create any xprofile fields in the new installation.
Install bp as you would on a fresh install..all tables and fields are created automatically
Ok thank you! I was by the way referring to the custom xprofile fields that I have on my current site (the multisite one that I have now).
I assume when I import the back up database file to the new site those custom xprofile fields would be created automatically.
Hi!
If I try to import the exported tables (sql file) in the new location’s database, following error occurs :
<br />
The error is mentioned there you need to figure it out
Hi!
I have somehow got this working. And I have the entire user data copied to the new location, Yay! 🙂
Now, the new problem is I cannot log in to the WordPress dashboard 🙁
Since I have dropped the users related tables of the new site and replaced them with the users related tables imported from the old site, I tried to log in with my admin credential (of the old site) which went through.
However, my admin username of the old site is no longer an admin in the new site! So, there is actually no admin user at all. How do I log in now?
Thank you for all the help 🙂
Hello @mairaj
I’m having quite a time trying to find the solution for importing the user’s data (specifically Buddypress extended data) and it looks like you had some success. Would you mind walking me through your process?
Also, I had similar problems logging into the dashboard after a user import – turns out my earlier attempt reset the “regsistered” COL and password. I figured it out in phpMyAdmin.
Thank you for any help!
-Graham
Closing in favour of https://buddypress.org/support/topic/import-xprofile-csv/, which the most recent responder also posted. (This thread was 4 months old prior to this last post).
