Support » Fixing WordPress » Merging blogs – kind of

  • 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?

Viewing 10 replies - 1 through 10 (of 10 total)
  • 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.

    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?

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

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

    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?

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

    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?

    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?


    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?

    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?

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Merging blogs – kind of’ is closed to new replies.