Push and Pull Individual Tables and Folders between staging and live environment
Hello team, pushing and pulling individual tables and folders between staging and the live environment is better compared to transferring the entire database or files. Because in Woocommerce, pushing the database might lead to loss of orders made in between.
When pushing live from staging or pulling from live to staging, it would be super helpful to be able to save sets of tables to include / exclude so that we don't have to check them on and off each time.
For example. with a multisite install with several sites, a site admin would likely want to exclude the wp_site, wp_sitemeta, wp_blogs and wp_options and wp_n_options tables for each site where n is the site id.
Being able to save that set would save time and insure no mistakes get made.
AdminCloudways (Admin, Cloudways) commented
The requested feature is available now. User can select which tables they want to push to live. For folders/files, the option is in consideration.
Braden Katz commented
Yes this would be a great and important feature to have. WooCommerce and gravity forms are both overwritten on the current method.
Igor 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.