My problem is this:
I am using MAMP to update many aspects of a WordPress site locally on my machine. Any change I make to a plug-in setting or any page/post attribute (not least of all, overhauling the homepage, or creating a new one) will update - for example - the wp_posts
db table.
Meanwhile, a collaborator is busy generating content for the website in real time - updating existing posts or making new ones - also changing the wp_posts
table and others.
If I upload the new db from my local machine to make it live, any work the collaborator has done is overwritten.
My proposed solution is this:
Put the primary ('live') db under version control (git in my case) as a remote (origin
) so that I can push local changes and merge them with the origin
database, using git push origin master
instead of overwriting it.
I believe the number of merge conflicts would be minimal.
My Question
Is my proposed solution possible? Or some variation at least?