Skip to:
Content
Pages
Categories
Search
Top
Bottom

Exporting and importing user data to a new site


  • mairaj
    Participant

    @mairaj

    Hello!

    WordPress 4.5
    BuddyPress 2.5.2

    I am looking out for some help on exporting and then importing my user data to a new installation / location. I will be fine with only the x-profiles data if messages, activity streams etc cannot be copied.

    The actual problem is that I am stuck with a MultiSite installation where my primary site is a BuddyPress website. I wanted to keep my BuddyPress site as a single (Non-MultiSite) installation.

    I have tried really hard to remove / disable MultiSite but nothing worked out for me. So now I am looking out to copy only my user data to a new installation / server. I would later delete my existing site and carry on with the new site with all my existing user data.

    Thank you for the help 🙂

Viewing 11 replies - 1 through 11 (of 11 total)

  • mairaj
    Participant

    @mairaj

    Any help for me please?

    🙂


    sharmavishal
    Participant

    @sharmavishal

    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.


    mairaj
    Participant

    @mairaj

    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.


    sharmavishal
    Participant

    @sharmavishal

    Install bp as you would on a fresh install..all tables and fields are created automatically


    mairaj
    Participant

    @mairaj

    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.


    mairaj
    Participant

    @mairaj

    Hi!

    If I try to import the exported tables (sql file) in the new location’s database, following error occurs :

    <br />
    SQL Error


    sharmavishal
    Participant

    @sharmavishal

    The error is mentioned there you need to figure it out


    mairaj
    Participant

    @mairaj

    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 🙂


    mairaj
    Participant

    @mairaj


    Graham
    Participant

    @graham2621

    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).

Viewing 11 replies - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.
Skip to toolbar