Skip to:
Content
Pages
Categories
Search
Top
Bottom

Migrating from one bbpress installation to another


  • Jason P
    Participant

    @specialtactic

    Here’s the scenario, and I’ll try to be as specific and detailed as possible.

    There are two different WP installations:

    • The first (let’s call it myforum.com) just holds a bbpress forum install with thousands of members and posts.
    • The second (let’s call it myblog.com) is an existing WP blog with thousands of existing posts&pages.

    We want to create a fresh bbpress install on myblog.com/forum and want to import all of myforum.com’s bbpressdata. We’re getting rid of the myforum.com site after migration.

    I am not a database guy however, and I have no idea how to export and import the forum posts as well as the users. I fear overwriting the existing posts, pages and users of myblog.com.

    Is it as simple as importing tables from wordpress onto myblog.com? Will that overwrite what’s already there?

    Appreciate any advice :)

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

  • Jason P
    Participant

    @specialtactic

    I’m in the “Import Forum” section of bbpress plugin – there’s no option to select for bbPress 2 (only bbPress 1). Or am I going about this the wrong way?

    I’ll be making various test imports in the using wordpress’ import/export in the meantime to see how far I can get merging these 2 sites.


    jasoncoffee
    Participant

    @jasoncoffee

    I have the same exact question.


    Jason P
    Participant

    @specialtactic

    Jason, what we’ve found so far, this plugin —

    https://github.com/pippinsplugins/bbPress-Export-and-Import

    It does the job exceedingly well. HOWEVER, our forum is so big the plugin cannot finish importing data. We use WP Engine for hosting, and they have a “Limit Script Execution” script that cancels any active script after 60 seconds. So we only have 60 seconds for the script to run.

    Now 60 seconds gets us about 20% successful import percentage of Forum Topics, Replies and User Accounts. Then we get a 502 Bad Gateway page.

    If it weren’t for the script timeout, this project would be done with. So for that, I am splitting up my export .csv file into 10 chunks. The original file is 25,000 lines or so. I’ll split them into 2k-2.5k chunks and import them one after another.

    Going to get around to that part either tonight or early next week. Jason, if you try it out please let me know how it goes :)


    Jason P
    Participant

    @specialtactic

    Was able to successfully import topics and replies using the plugin mentioned above. Had to split up the CSV’s into 20 smaller chunks. (I used MS-Notepad for this, as Excel was inserting some weird formatting and causing errors.)

    However, it seems that 80% of the users are missing. Original Forum has 2,200 users. After import, I have only around 450.

    Will continue to attempt to work with this plugin as well as posting my progress here for people who may be searching with this same issue (while hoping for someone who has accomplished this tremendous feat to come around ;-) ).


    Jason P
    Participant

    @specialtactic

    Okay just realized that it’s only showing 450 users because it ONLY creates a user IF they posted or replied to a topic. Looks like 80% of the users never posted, so they didn’t get their account created.

    This doesn’t explain why it’s showing the WP-Admin as the author for a majority of posts in the forum though (even though they are verified users in the system).

    Next step I’ll be taking is finding a WordPress user export/import tool. Importing the users FIRST, and THEN importing the forums. Let’s see if that makes a difference.


    Jason P
    Participant

    @specialtactic

    Exciting news!

    The forum was imported successfully to a test development site.

    I used the plugin “Export Users 2 CSV” by Yoast ( http://wordpress.org/plugins/users-to-csv/ ) to import users.

    Then I used a modified version of Import Users by DagonDesign ( http://www.dagondesign.com/articles/import-users-plugin-for-wordpress/ ) to import the users.

    Important Note: When importing users with this plugin it WILL send notification emails to the Admin and the User. I ALMOST pressed “go” on importing 2,200 users — but then I decided to check the plugin code just in case; sure enough there’s this line of code wp_new_user_notification($user_id, $password); you should delete or comment out.

    Yes, the users will have to re-create their passwords. We will instruct them how to do that on the new forum. That’s perhaps the only drawback of this method. But since out of the 2,200 users there are perhaps only 100 current active users, it shouldn’t be too much of a hassle.

    I did have to write a custom PHP script to help this user export/import process, because the import and export plugins do not match in formatting. You can either do this custom in CSV or make a simple PHP script (took me 10 minutes) to take data from the export CSV and reformat it to meet the delimiters and the stricture of the import CSV. I can help people with this, just ask.

    This user import/export had to be a separate process because using bbPress Export and Import by PippinsPlugins ( https://github.com/pippinsplugins/bbPress-Export-and-Import ) did not properly attribute users to posts if it had to create the user. (It attributed the admin to most of the posts.)

    After the users were imported, I imported my 20 CSV files (~2,000 rows each file) and after much scrutiny in examination, I find that all users have been properly attributed to posts.

    Now all that’s left is performing this process again onto the live site, the fresh bbpress install. (Remember, always back up your site and database before you do this stuff.)


    Halo Diehard
    Participant

    @halo-diehard

    I too am trying to import an existing bbPress into another WordPress site, and as a note I must say that the reason I have to do this is because the bbPress importer does not play well with my server (or I SHOULD say my server does not play well!) and I get a similar result you speak of, @specialtactic, where the majority of the posts are attributed to the admin. This has been verified as not being a bbPress importer issue, but a server issue, as I was able to use the importer successfully on my local test server.

    Now that I know I can import onto my local, I need to be able to import that local bbPress (converted from the phpBB3) into my live WordPress site, but alas I haven’t had the time to try and wrap my brain around how to accomplish it and so have been waiting for an importer to be written.

    Just wanted to clarify for you that it’s possible that the PippinsPlugins is not at fault, if you were attempting to use it in similar circumstances to my own.


    Jason P
    Participant

    @specialtactic

    Well perhaps I was being silly to begin with – the bbPress import/export tool didn’t seem to list bbPress 2.x on their options. There is a slim chance I did a lot more work than I needed to. However, at the end of the day, the hard work is complete. Over 8,000 threads + replies imported, as well as over 2,200 users. All users properly associated with topics.

    The key step was importing users as a separate process — do it BEFORE you import forum threads+replies! When I relied on Pippin’s plugin to do this, it associated the users to admin. It was very messy. Using an existing plugin (make sure you tweak the import plugin to *NOT NOT NOT* send WP notification!) I was able to do this process very fast.

    I used the plugin “Export Users 2 CSV” by Yoast ( http://wordpress.org/plugins/users-to-csv/ ) to import users.

    Then I used a modified version of Import Users by DagonDesign ( http://www.dagondesign.com/articles/import-users-plugin-for-wordpress/ ) to import the users.

    Again, you will need to instruct your users to fill out the Lost Password form, as these plugins do not preserve MD5+salt.


    Bolder Elements
    Participant

    @hystericallyme

    Anybody tried this recently? I got my hopes up when I saw this post, however when I try to export using the plugin suggested, I receive these error messages:

    https://github.com/pippinsplugins/bbPress-Export-and-Import/issues/2

    All I wanted to do was move from one install to another :(

    I have just created a ticket on Trac to add a bbPress 2.x to bbPress 2.x importer.

    https://bbpress.trac.wordpress.org/ticket/2605

    I have no idea why I had never thought of, or had mentioned or requested previously to include this. It should be pretty quick and easy to do also.

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

You must be logged in to reply to this topic.