Workflow for updating complex database websites locally

Guys, this issue has been killing me. I would really appreciate someone knowledgeble that can help me wrap my head around this.

I build a Wordpress community website with forums, shop, directory, etc a pretty complex site locally. I added it to GitHub and pushed it to a live server, with a seperate database via SSH.

I want to be constantly working on upgrading and updating the website locally, but I can’t wrap my head around how to appropriately work with the now split versions of the two databases. If I add a new plugin locally, it changes the local database, as they are now split.

I can add structural changes and push it to GitHub and pull it live, that would work fine, but then I cannot edit any plugin locally. It’s an ill-concieved process, there has to be a “right” way to do this.

Please please help,
Anton VS

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.