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:
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.