Merging blogs - kind of (11 posts)

  1. Janzomaster
    Posted 9 years ago #

    Hi, I got two blogs running, one which is in use and one, on my new host, with a couple of new fancy plugins.
    As my domain will be transfered to the new host soon, I want to get all the posts, pages etc. to the blog on the new host, without losing all my configuration and plugin stuff I currently have.
    Is it possible to just import the post-relevant tables in the new blog? Or are there certain settings in other tables like wp-config which are not transferable/would need manual tuning?
    Right now, I would import all tables except wp-config. Will that work?

  2. moshu
    Posted 9 years ago #

    Hmm... I don't see any "wp-config" table in the database.

    Merging two WP databases (or trying to do it) always gets stuck with the following questions:
    - what will happen with the posts that have the same ID#?
    - there are many relational data stored about a post (or Page), what will happen to those; e.g. the category they are assigned to in the post2cat table...
    - comments: their ID# and to which post they belong

    I can't really remember a working solution for it.

  3. Janzomaster
    Posted 9 years ago #

    Well, merging probably wasnt the right word. I dont want to keep any of the posts in my new blog - just the config (wp_config is the table I meant). The rest of the tables would be emptied and then filled with the data from the old blog. Does that work?

  4. moshu
    Posted 9 years ago #

    Once again: there is no wp_config table in the WP database. I don't know where do you see it.

  5. Janzomaster
    Posted 9 years ago #

    hey, I messed up again. I'll give it another try: wp options

  6. Janzomaster
    Posted 9 years ago #

    Is it possible to empty the content of every table except wp-options and import content for the tables from a different blog or will everything be messed up?

  7. moshu
    Posted 9 years ago #

    If both blogs have WP 2.2. - can't you just use the export/import feature?

  8. Janzomaster
    Posted 9 years ago #

    I slowly get the feeling I'm kinda slow... Export does exactly what I want...

    Another question: Is there a way to delete all the types of content "export" would export other than working at the sql-tables, so everything is clean for the import?

  9. Trent Adams
    Posted 9 years ago #

    Exporting your content is the authors, posts, pages and comments (including spam). The only thing I would suggest is dumping akismet queue (if you have it) and then export the file for import. WP will put in the new entries in the right order with the right timestamps and there is nothing extra you should have to do.

    Uploads and files would need to be moved over manually though. Is that what you mean?


  10. moshu
    Posted 9 years ago #

    so everything is clean for the import?

    You are kind of "obsessed" with this cleaning thing. What is it exactly you don't want to export/import?

  11. Karenscott
    Posted 8 years ago #

    I currently have two blogs.

    My current blog keeps having outages, so I switch to my spare blog.

    I would like to pull my posts from my spare blog over to my main blog.

    If I use the import action to try to pull the posts from my spare blog to my main blog, do I run the risk of losing the stuff that's on my main blog already?

    Also, can I pull over just the posts and the comments. If so how?

    I was thinking that if not, then I could pull all the posts from the spare blog (there are only about 10 posts), then just delete the ones I didn't want.

    Would this work?

Topic Closed

This topic has been closed to new replies.

About this Topic