Thread tagged as: Question

Merge content from two blogs?


A client website features two blogs, 'Blog A' and 'Blog B'

My client has asked if it's possible to move all the posts from 'Blog A' to 'Blog B'

Is there a way to change what blog 'owns' a post? Perhaps editing something in the database? Is this possible?

Or is a copy and paste job in my near future? :)


Stephen Meehan

Stephen Meehan 4 points

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Do the blogs have different categories and sections etc?

Yes, each blog has one category.

I think the plan, when it was setup, was they wanted to add more categories and fill out each blog, but that's not happened. And now they'd like to merge the two blogs into one.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Try it locally on a copy first, but you should be able to update the blogID for each post. Something along the lines of

UPDATE perch3_blog_posts SET blogID = 1 WHERE blogID = 2;