Backup a Drupal site's database using drush, minus disposable data.

site-db-backup

#!/bin/bash

# Check for the existance of drush on the system
if [[ ! -x /bin/drush || ! -x /usr/bin/drush ]]; then
  echo "This script requires drush!"
  echo
  exit 3
fi

if [[ -z ${1} ]]; then
  echo "Must specify destination directory for backup tarball"
  echo
  echo "Directory can be a complete path, or a relative path"
  echo "Ex: backup-site ~/backupdir"
  echo
  echo "Enjoy!"
  echo
  echo
  exit 2
fi

# Setup the backup prefix
BACKUP_PREFIX=${1}/$(hostname)

# get the date
DATE=`date +%Y%m%d`

# Dump the Drupal DB structure only
echo "Dumping database and compressing . . ."
drush sql-dump | grep -Ev "^INSERT.*(cache_.*|flood|search_.*|semaphore|sessions).*$" | bzip2 > ${BACKUP_PREFIX}-${DATE}.sql.bz2

echo "Done!"