Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I have two Wordpress installs, both with a little bit of different data.

I have a LIVE site and I have a DEV Site. I need to merge the content of these two databases together to make a STAGING Site.

I need to merge the new Posts/Pages/Comments/Categories from DEV to a LIVE database backup, and then make that database become STAGING.

What is best, easiest, and least time consuming way of tackling this?

NOTE: XML Importer will not work for this task as the amount of data is too large.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

NOTE: XML Importer will not work for this task as the amount of data is too large.

This tool is by far the simplest solution if there's any way you can get it to work. Is it absolutely "too large" for the importer, or just limited by file upload / PHP execution time limits? If I were doing this, I'd crank up the limits on my development environment to process a really big XML file.

If that won't work, I'd probably guess that you have some mucking around in SQL to do. :-P

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.