I have many sites deployed on many different environments for many different clients. I develop locally, version control with git, and deploy with Beanstalk, but this doesn't cover changes the clients make through the backend (therefore the database) and files they upload. When it comes time for maintenance or further development and bug fixes, I feel like I'm starting over from square one as if I wasn't using git: hunting down changed files, comparing dates of files, diff'ing SQL dumps... What's the best way to track changes on a deployed site?
Specific case:
- WordPress Site for Large Client
- Hundreds of new posts a week
- Post attachments and images
- New users registered for the site
All of this is data I would like to work with locally.