oheric.com

/base/(head)|(stable)

• Core system + select essential contribs

/sites/[name]

• Drupal sites dir for each site.
  • settings.php
  • database.mysql (prod snap)
  • themes
  • modules
• ACLs prevent snooping.

The auto database backup feature needs some thought. Database/sitename.mysql should always be a recent copy of the production database for the site. The main question is, when are backups made? I'd backups to be user-driven rather than timed. Ideally, checking out a new copy of the site should result in the creation of a db backup. Unfortunately, hooks are only fired on commit, not checkout. Since there are so many questions, we should start simple. I'll just make a script which parses $1/settings.php for $DB params, dumps to $1/database.mysql, and commits $1. Simple and useful. It may be necessary to play with the diff settings to get reasonable patch sizes.