Skip to:
Content
Pages
Categories
Search
Top
Bottom

how do i move one site’s content to a dif. site?


  • freddy mcbob
    Participant

    @yeshourun

    12 years, 2 months ago

    I have 2 buddypress sites. But I want to move all my content from the first site to the second site (including: activity feed updates, groups, forums, except members.) How do i do this?

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

  • Roger Coathup
    Participant

    @rogercoathup

    12 years, 2 months ago

    Your items (activity, groups, etc.) will all have member IDs in them, and other key fields.

    If you try to move those tables without moving the members table as well, you will lose all the keys, and the items will not function correctly.

    If you want to move them ‘programmatically’ and assign the items to different members, you will need to write a very sophisticated import routine — remember some items such as activity updates have multiple ID fields that you’ll need to manage.


    freddy mcbob
    Participant

    @yeshourun

    12 years, 2 months ago

    iv managed to move the members table with SQL but do i move all the other stuff i want to move with SQL also?


    Roger Coathup
    Participant

    @rogercoathup

    12 years, 2 months ago

    Using phpmyadmin.. Export your tables to file on the source site, and import from that file on the destination site.
    There are plenty of tutorials on moving a WordPress site.. Have a Google.


    Traek
    Member

    @traek

    12 years, 2 months ago

    I just got done doing this last night with one of my sites. It was PAINFUL because I created a few users first before doing the import. This unfortunately led to me having to renumber a LOT of records that linked posts (including activity) to individual users. For what it’s worth, here are the tables that I moved using phpMyAdmin that seemed to get everything I was looking for:

    Assuming a prefix of wp_ for your database (mine was not and yours shouldn’t be either so change as necessary):

    wp_commentmeta
    wp_comments
    wp_bp* (everything here was critical for activities, existing friendships, etc.)
    wp_usermeta (this was critical to get the users to show up in the members list)
    wp_users (duh)

    The big question is why did you want to not bring the users over? Everything you mention initially is tied to a user: activity, forum posts (unless you just want the empty forums themselves, that’s easy) and even groups (someone had to create them). What are you really trying to accomplish and maybe we can help with a little better understanding :-)

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘how do i move one site’s content to a dif. site?’ is closed to new replies.

Topic Info

Topic Tags

Skip to toolbar