Improve WordPress Staging: Selective Database Sync
The actual staging feature was a big step forward to deal with business related WordPress sites.
But for now only the entire database could be pushed/pulled between staging <> live environment.
For more complex WordPress sites with WooCommerce or membership systems the actual staging feature is not enough. While in staging mode the live site changes permantly and new orders/users are created. When pushing back the entire datebase all changes would be overwritten!
A selective database sync (select which tables should be copied) would really improve the staging feature. With that in place Cloudways would be a very good host even for these complex WordPress sites.
PS: A similar feedback was already posted but with bad explanation:
Dimon Pokemon commented
Friends, we are often asked by the question - to be or not to be -
For all Internet lovers, https://www.netshop-isp.com.cy/ I offer a cool life hack, you will become the happiest web hosting owner, if you want it, of course. Good luck
I suggest it's also important to be able to select which files/folders to push/pull. On sites with massive amounts of images, it seems to take a really long time for the staging system to push/pull. As all but a few (the latest since last push/pull) of those images never change, it seems pointless copying them all back and forth each time. Doing a push/pull on our largest site can take around 45 minutes each time. It's somewhat ridiculous.
Burger King is the American Global Restaurant chain offering their customers to give feedback on their customer satisfaction survey. The survey is to know how customers feel about their service and products.
The recent reports suggest that Ali Reza has reportedly been elimination from the most controversial show in India, Bigg Boss Season 3 Telugu. The superstar, Akkineni Nagarjuna helms the role of the host of the show. https://www.telegraphstar.com/category/entertainment/
When you enacted the module, go to the WP Staging - > Create New Staging Site. Give the site a name, for this situation, it's organizing, and check every one https://www.assignmentspot.co.uk/ of the Files and Database Tables you need to duplicate. Furthermore, when you're set, click Start Cloning. Significant: Create a reinforcement record before making an organizing situation for your site.
The actual staging function is only useful for small standard sites. Any larger site has specific functions which change the tables all the time.
These changes get lost on Cloudways without the ability to choose which tables should really be pushed back into live site.
Roman Makarenko commented
Excellent information, I was just thinking how to make it so that you can selectively synchronize my database. Thank you so much for sharing this information, it's not so much on the Internet.
Roman, writer from https://medium.com/theymakedesign/top-branding-agencies-bcf12154af9b
Thanks for the useful information, to me as a WordPress user, this was very important.
Would be great to have a selection like on WP Enginge.
Peter Hiller commented
The missing selection which databases to sync from staging to live keeps us from switching to CW.
We use an LMS plugin and members are logging in all the time and their course states change. So we need the ability to exclude certain tables from synching. Otherwise all changes while working in staging get lost after pushing back to live!
An arranging webpage is a clone of your live site. Developers regularly use arranging locales as a proving ground so as to anticipate mistakes happening on 'live' sites, therefore dodging the issues as well as a vacation that may somehow result. Staging destinations can be set up utilizing an assortment of strategies. http://www.essayempire.co.uk
Yeah that would be really helpful! Actually we can't move our WooCommerce site to Cloudways for this reason.
And please add the ability to have different .htaccess files for staging and live.