We develop WordPress websites and we have returning customers who request revisions to their website that require us to develop in a development environment before publishing to production (live). The challenge has always been how to merge two WordPress databases that are out of sync but have mutually new content that must be retained.
This content ranges from Pages, Posts and Comments to Plugin settings and other subtle information. So we export both databases and use FileMerge, for Mac, to display the differences and manually merge them. This would be fine if the WordPress databases didn't contain so much meta information that is, otherwise, human unreadable (examples below).
We're looking for someone to create a solution for us.
FYI WP Migrate DB (including Pro) is not capable of this. We spoke with the authors.
The following is a list of database records that I think could be omitted without causing any conflicts in the database. - _transient_random_seed - active_plugins "a" value (which I believe represents the number of active Plugins) - _site_transienty_timeout_browser - recently_edited - db_version - cron - _transient_timeout_feed_mod - _transient_feed_mode - rewrite_rules - Plugin Versions - _edit_locks