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:
http://feedback.cloudways.com/forums/203824-service-improvement/suggestions/34850656-ecommerce-staging-enviroment-enhanchment

60 votes

Jeff shared this idea · Jul 3, 2019 · Flag idea as inappropriate… · Admin →

completed · Jun 4, 2020

27 comments

An error occurred while saving the comment

Anonymous commented · August 9, 2019 7:30 PM · Flag as inappropriate

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.

Submitting...
Roman Makarenko commented · July 24, 2019 7:32 PM · Flag as inappropriate

Hi,

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.

Best,
Roman, writer from https://medium.com/theymakedesign/top-branding-agencies-bcf12154af9b

Submitting...
Ben commented · July 23, 2019 12:54 AM · Flag as inappropriate

Thanks for the useful information, to me as a WordPress user, this was very important.
https://www.pngix.com/

Submitting...
Paul commented · July 21, 2019 3:06 AM · Flag as inappropriate

Would be great to have a selection like on WP Enginge.

https://wpengine.com/support/staging/

Submitting...
Peter Hiller commented · July 11, 2019 12:52 AM · Flag as inappropriate

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!

Submitting...
PeterFinch commented · July 10, 2019 8:02 PM · Flag as inappropriate

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

Submitting...
Scott commented · July 4, 2019 6:36 PM · Flag as inappropriate

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.

Submitting...