Okay so first I have to say I’m pretty new to development. I am decently handy with HTML, CSS, and JS, but I know very little about the fundamentals of backend, and I basically just know how to make my own theme in WP by using ACF, CP UI, and a little bit of PHP loops/queries etc.
Local has made the process of handling my local development much easier, but having got my first WP portfolio website live, I’m having trouble wrapping my head around the workflow I should use to keep deploying changes to my code and database simple.
I currently have a program called GoodSync that allows me to sync a local folder on my computer with the FTP. It’s kind of like setting up a dropbox except it’s p2p. I add a file to my local folder and it will automatically upload to the website.
I’ve only set it up to sync the wp-contents folder. The config files should remain separate between the local and live website.
I’m wondering if anyone had a suggestion for some kind of automated system for deploying the database updates to the live website?
Is there a preferably free plugin that handles this well?
I’ve also heard a lot about using git for deploying changes to code to the live or staging website. This is good for changes to theme code but not to WP-upload correct? Because wp-upload is going to be media files which are binary and therefore don’t upload easily right?
And git deployment doesn’t take care of database stuff so how do people deploy changes to database using this method?