I've tried to be as descriptive in the title as possible, and I know this question has been asked in before in various forms but I could not find good answer to it and it's are to imagine that no one has solved this issue.
It's simple, once a WP site is live, if it is not a static one then it keeps updating it's database by having new posts added, new woocommerce orders, new user accounts etc'
If I want to make some major changes and updates to the site, the simplest and easiest way to do this is by making a copy either to a local install or to another development domain, and making all the changes there. Once all the changes are done I want to copy them back to the live site.
If the changes are to files only, like theme and css, that's somewhat easy. However, if the changes involve changes in the database, like adding new plugins and adding content that connects/relate to these plugins, then I no longer can just copy the site back, because it will override any new changes that got added to the live site's database. all new posts, new orders, new image uploads, will all be erased.
Now I know that different case scenarios have different solutions, but isn't there a method that address all cases?
For example, if the only changes that were made to the live site were new posts, then I can export and import the posts to the dev site and then move the entire site over. Same with some other items, but not every kind of item. And the other problem with this is that the export and import function in wordpress is abysmal. It is so rudimentary and you have very little options to select and export only specific items. I've probably tried every "advanced import/export" plugin out there and nothing has yet to solve this issue.
So in another thread, someone pointed out this plugin to basically install and work on a theme on the live site, while the regular users still see the existing theme, but that still doesn't solve all types of changes. because if you want to make changes to content, let's say the footer or nav menu, it is things that will still reflect in the existing viewable theme/site and might look ok on the new test theme but not the live one.
Is there no way to develop a "branch" of a site on the same site/database and then switch? or is there no way to develop on a dev site but then actually merge databases in a non-destructive way? If you know which components and things you affected, wouldn't there be a way to do that? or would you need to be a MySQL master to attempt such a thing.
I can't be the only one having this conundrum. I can't imagine there is no solution for this issue. How can this be done?
Thanks in advance.