10 votesIgor Honhoff commented
This is not just in Woocommerce. There are a lot of plugins out there that add isolate their data in seperate tables, not to mention the built in comment functionality. I also often make changes that only affect the options table when developing plugins and would like to push the option changes to live but not touch the posts, which in my case could be created by clients in live in the meantime.
17 votesIgor Honhoff commented
I have the same issue on my site. I contacted support to help me with this and they were able to successfully replace all the urls in serialised arrays but this should happen automatically when cloning or creating a staging copy.
26 votesAdminCloudways (Admin, Cloudways) responded
Thanks Paul. Would a docker image suit the same needs?. Assume so. We are leaning towards it for the exact same problem you mention.