Ways of managing staging and production wordpress sites?
Ok, I’ve seen a lot of similar questions.. but they all either outdated or do not fall in in my problem.
So the problem is:
We have a website and its clone stage website. On that website, apart from me also works Content Manager. She manages content(banners, text, gallery and so on)
When we need update website to new WP version or theme version or tweak/fix something we do it on our stage clone website. Once we are happy we clone it over to production one. Easy-peasy-lemon-squeezy. But! Sometimes the process of tweaking/fixing and updating takes longer than few hours or even days, and during that time the live site may get new content. And here is the dilemma. I have to then clone fresh version of the production site over to stage one and apply updates again. And that’s totally insane in terms of productivity and time. I could teach our Content Manager how to do cloning in ManageWP(the service we use) but first, this is not her area of responsibilities, second it’s not safe.
Sorry if it took me long to explain, but tried to give you a better picture of my problem.
So the question is, how do we streamline upgrading/updating live site from production without rewriting content?
Is there any tool to selectively update Database?
Or is there any option to separate Databases in WP? Make one only for content(posts, pages, media references so on) and another one for the rest backend kind of stuff?
Thank you for your attention and input