I have a bunch of live sites that I'm debating bringing into a multisite installation. It would take a bit to set up and configure, of course, and ideally I'd do it locally over a period of time, then upload somewhere.

Of course, these sites are still live, and are still being updated, some on a daily basis.

Is there a way to import pages/posts so that changes are overwritten? So let's say the "About" page is changed live - I want to bring it into my test site while it's in development.

Or in other words - I don't want to lose any live content changes while the site is in development.

What's my best method of doing this?

  • To be clear do you mean that you want to import&overwrite from production single site to a dev multisite? That might be messy... – Rarst Oct 26 '16 at 18:03
  • heh I know :P i'm just trying to figure out a way to maintain the content while working on it in a dev environment. – Jamie Oct 27 '16 at 14:38
  • Typically I would recommend to just copy whole database over, but it won't fit single/multi mismatch. – Rarst Oct 27 '16 at 14:42
  • hmm, would it make sense to just copy over wp_posts? (and of course, rename it to whatever site ID the site in question had) – Jamie Oct 27 '16 at 17:12
  • i feel like there should be a functionality like this, even if just single-site to single-site, to the basic WP export plugin... – Jamie Oct 27 '16 at 17:13

A good way around this I've found is to modify your local wp-config.php to access the remote database directly. You often have to enable remote sql in CPANEL. Then you enter the remote host URL in the define('DB_HOST', 'yoursite.com'); part of the config.

  • I don't see how this will help said user import pages from one install to another. Could you edit your answer and expand on this further ( by clicking the edit link above )? – Howdy_McGee Feb 13 '18 at 17:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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