Support » Fixing WordPress » Sharing posts between seperate WordPress instances

  • I have two WordPress blogs set up on the one hosting account, and sharing the same database. and

    What I’d love to be able to do is to have posts of certain categories shared between blogs ie, if I post to the ‘ac’ blog under category ‘fun’ then the post will also appear in the ‘bm’ blog, or if I post in the ‘bm’ blog with category ‘work’, have the post appear in the ‘ac’ blog.

    Is this at all possible? At present I’m having to re-key the posts into each blog, so it would cut down the workload significantly if I could set something like this up.

    Although both blogs share the same database, they have differnet table prefixes ‘ac_’ and ‘bm_’

    Any help duly appreciated

Viewing 3 replies - 1 through 3 (of 3 total)
  • >Is this at all possible?
    Sure, it’s possible. Its just a matter of how well you know your SQL. Modify the post selection queries to join in the result of the query of the other tables and that should be that. You might have an order problem that you need to watch out for if the query engine doesn’t resort the joined tables. And you might have some wierd results if your user IDs don’t match up, but it’s possible.

    Frankly, I don’t know if it will be worth your effort. You’ll have to, amoung other things make sure that you change the autoincrement values for one of the blogs so that the IDs for the posts are unique and I’m sure there are several places where the posts are pulled in unique manners (RSS feeds for example) that will have to change too.

    It might just be easier to copy and paste the posts.

    RSS feeds for that category + a feedreder? In both directions?

    Yeah, I briefly thought along those lines too. Setup a third blog that is used as a feed for both. Or use the email submission and cc the second blog. Just some thoughts…

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Sharing posts between seperate WordPress instances’ is closed to new replies.