I've already looked at this question and didn't find it too helpful.
We're using Wordpress as a CMS that also includes a blog/news section. The blog/news uses WP "posts" and those are made whenever and are j
We're already using version control for the files, so that's simple enough. The main issue is the database. We basically want a selective backup that excludes posts. Are there any best practices or well tested ways to do this?
I'm comfortable enough with sql (not specifically MySql, but the dialects are similar enough I'd think) that I could come up with a script to do it, but I'd rather not risk subtle errors if there's already a well-tested solution available.
If there isn't already a solution, are there any caveats or pitfalls I should be aware of when doing this? Any relevant articles that would be helpful in preparing this?