WordPress.org

Ready to get started?Download WordPress

Forums

How to merge three different wordpress blogs (21 posts)

  1. pelles
    Member
    Posted 9 years ago #

    At the moment I have three different wordpress blogs in two different MySQL-databases at two different servers for various reasons. Is there a way to merge these into one?

    I have tried searching but I can't seem to find an answer for this. If there is please point me to any relevant support pages.

  2. Marc
    Member
    Posted 9 years ago #

  3. Kafkaesqui

    Posted 9 years ago #

    Uh, the link above will not help you.

    What you're looking to do can be done, but it won't be easy, and will require quite a bit of massaging of the SQL data. I'd suggest searching through the forums, though you may find some of the information discouraging.

  4. Marc
    Member
    Posted 9 years ago #

    If you move all three blogs onto the same server the above link will assist you.

    Sorry I forgot to add that caveat.

  5. moshu
    Member
    Posted 9 years ago #

    Marc, sorry, but that will not help him (as Kafkaesquí said) because he wants to have one single blog with the content from the existing 3. Which means combining the 3 DBs in one, and that's quite nightmare-ish :)

  6. ekgermann
    Member
    Posted 9 years ago #

    http://blogs.semperen.com/notabene/2005/05/17/meta-blogging-comes-to-semperencom/

    combine them this way and set it to set the permalink to the combined site, not the source site. Then just update the combined site in the future. voila, combined blog.

  7. pelles
    Member
    Posted 9 years ago #

    Thanks for the suggestions so far. Kafkaesqui and moshu seems to be closest to what I have in mind. But it seems really complicated. Wouldn't it be possible to modify one of the import-scripts and simply inport the posts and comments, which are the only stuff I want to merge into the new blogdatabase.

  8. angsuman
    Member
    Posted 9 years ago #

    It requires you to manually merge the contents of four tables, not very complicated, shouldn't take you more few hours at most, if you do it carefully and have phpmyadmin installed.

    Backup first.

  9. Kafkaesqui

    Posted 9 years ago #

    Some important points on this:

    1. The main tables that would have to be *handled* in a merge: wp_posts and wp_comments. It's possible wp_categories and wp_post2cat would we needed (if a blog has categories you wish to preserve), wp_postmeta, and even wp_users. (Note the table prefix may vary.)

    2. The difficulty in merging two or more databases/table structures is the unique identifiers for the various components; ID for the posts table, comment_ID for comments, and cat_ID for categories (and let's not forget rel_id in post2cat, meta_id for postmeta and ID for users). These values could be NULL'ed in the dump file and an import would correctly reset them, but you still lose the connection that exists between post<>categories in post2cat and post<>comments in comments (as well as post<>custom field data in the postmeta table, and user<>post in the post table).

    3. All this is easy to manage if were talking about a few, or few dozen, posts from the database(s) to be merged. You could import the posts, collect the new post IDs, and modify the other tables in the dump file to point to the correct (i.e. new) one. When it gets to hundreds of posts this becomes difficult.

  10. leilers
    Member
    Posted 9 years ago #

    I'm in the position of wanting to do the same thing - merge three different wordpress blogs into one. The total posts are definitely in the hundreds, if not thousands. Not being a mySQL goddess, I'm beginning to despair of finding a way to do this.

  11. nearlythere
    Member
    Posted 8 years ago #

    I'm not sure if you solved this or not, but I 'simply' exported to the moveabletype format, then imported back to the other wordpress blog. my only trouble is that it messed up my japanese writing.

    the handy WPexport plugin:
    http://epierce.blog.usf.edu/?p=15

    and the import instructions:
    http://codex.wordpress.org/Importing_from_Movable_Type_to_WordPress

    did you find any other solutions?

  12. nearlythere
    Member
    Posted 8 years ago #

    i just want to add that using this method worked perfectly, my only problem was i needed to save my japanese text as UTF-8 and it was no prob!

    exporting via the WPexport plugin, and import-mt.php brings in all posts, the authors, and comments. no problem!

  13. archshrk
    Member
    Posted 8 years ago #

    Does this method require movabletype or can I just import the export file? I have a blogger account if that's the case.

  14. nearlythere
    Member
    Posted 8 years ago #

    nope, you don't need MT. if you can imagine that you're just dumping out all the content you need, saving it as a text file, and importing back into the other WP blog.

    so, the WPexport plugin, and the import-mt.php just help you manage moving the file from one wordpress blog to another!

    it's brilliantly easy!

  15. archshrk
    Member
    Posted 8 years ago #

    Oh my gosh, that was so easy. Only hang up I was looking for an export function when i just needed to copy/paste the posts to export (via plugin) See all my "new" posts at http://archshrk.com

    Thanks nearlythere!

  16. archshrk
    Member
    Posted 8 years ago #

    I spoke too soon. There were a couple of problems. Some posts were doupble posted with the comments divided between them. Some were catagorized incorrectly. An some had their comments closed. Still the best solution I found but not fool proof.

  17. nearlythere
    Member
    Posted 8 years ago #

    As far as I know, the import-mt.php closes all comments on import.

    That's a bummer about the double posting. I didn't have any trouble. I wonder, if there was something messing with the pattern, you know, of -------- lines between entries?

    I didn't have any troubles with categories either. I wonder what went wrong. Hmpf.

  18. archshrk
    Member
    Posted 8 years ago #

    After I cleaned up my posts I realized I was probably the cause. I had manually recreated some posts previously so the name, date-stamp and even the comments were the same. Openning the comments was easy enough since I didn't have too many posts but older ones are less likely to get new comments anyway. My other problem was that the users ranged from () to administrator to archshrk. I didn't catch the importance of changing that during the import but easily found the fix using "search" (did require running a SQL command)

  19. leilers
    Member
    Posted 8 years ago #

    The WPexport plugin didn't work for me. In fact it broke my WP 1.5.2 installs in some way that I wasn't able to figure out.

    Does anyone else have any ideas about how to combine three WordPress databases into one?

  20. leilers
    Member
    Posted 8 years ago #

    I'm still stuck with this guys. I've tried two different exporting plugins but have had no success with either one. The only reason I want to export is so that I can import the results into another wordpress blog. Trying to combine three databases into one was just too unwieldy for me.

    Surely there are people out there who've wanted to export their wordpress for whatever reason!

  21. kilwag
    Member
    Posted 7 years ago #

    Ugh. I need to do this soon. That's why I'm here. I'm going to cross my fingers and hope the export/import will work. I'll post my results either way, some time early in the new year.

    leilers - what broke, or what was the end result?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags