Using git to track a drupal database

Create empty branch in git

  • just do for the first time
git symbolic-ref HEAD refs/heads/db 
rm .git/index 
git clean -fdx 
git commit --allow-empty -m 'Initial commit'

Dumping the database

  • pre-requisite: drush, maatkit
  • repeat whenever needed
drush cache clear
mk-find pd --tbllike "cache%" --exec "TRUNCATE %D.%N"
mk-find pd --tbllike "watchdog" --exec "TRUNCATE %D.%N"
git checkout db
cd /var/wwwroot/project/db && \
rm -rf && \
mk-parallel-dump -d MYDATABASENAME -- mysqldump --skip-extended-insert --skip-comments --skip-lock-tables '%D' '%N' \> '%N.sql'
git commit -m"commit message"
howto/vcs/drupal-database-in-vcs.txt · Zuletzt geändert: 2010/02/23 10:53 von hinnerk
CC Attribution-Noncommercial-Share Alike 3.0 Unported
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0