-
Challenge: Not sure which table should I be looking for, if I want to grab the latest changes of pages from my live site, and merge it into my staging site, but without overriding my staging site’s pages content that I build with gbgp.
Context: My current live site is almost 160GB and it’s way too heavy, however the live site still needs to run and there are things like “donation” that I need to keep the data always up-to-date. Hence I want to create a staging, clean up there, and then only when I’m ready, to push the full new set of data back to the live site.
-
Hi there,
Post and page data live in the
wp_postsandwp_postmetatable.Just a heads up, what you’re trying to do is quite complicated. From my experience, there’s no clean way to merge them at the database level manually, unless you already have a specialized tool to handle this?
-
Hi Alvind, thank you for the quick reply!
I’m currently relying on two tools to do something like that. I’m using xCloud for hosting, and I’m using WP Migrate (Plugin) for all the push-pull between the local instance that I’m running on WP Local and the live instance that I’m running inside xCloud.
Does that help?
-
Ah okay, unfortunately I haven’t used any of those tools, so I can’t really speak on them.
If WP Migrate has a database merging feature, that could potentially do it. You would need to check with them to see if that’s available.
- You must be logged in to reply to this topic.