WordPress database synch between dev and prod
Question has been asked before about how to synchronize files as well as the database between two WordPress installations.
sync
WordPress as XML-RPC client?
I want to sync post edits on two sites. Test environment, not production. Single direction (site A to site B, but not backwards).
Staging sites, how do you manage synchronising updates in the DB?
It is broadly accepted that developers should test updates through a staging site before releasing them to the live server, however once the development updates require modifications in WordPress DB, things get complicated, as users in the live site will update the DB too.