drupal db backup script

drupal-backup.sh

#!/bin/bash
# usage: drupal-quick-dump user host database

usage() {
  echo -e "usage:"
  echo -e "\tdrupal-db-backup [dir]"
  echo -e "params:"
  echo -e "\tdir\tdirectory for the settings.php file"
}

if [ "$#" -lt 1 ]; then
    usage
    exit
fi

DIR="$1"
# DIR=/var/www/html/sites/default

DB=$(grep -F "'database' => '" "${DIR}/settings.php" | cut -f4 -d\')
USER=$(grep -F "'username' => '" "${DIR}/settings.php" | cut -f4 -d\')
PASS=$(grep -F "'password' => '" "${DIR}/settings.php" | cut -f4 -d\')
HOST=$(grep -F "'host' => '" "${DIR}/settings.php" | cut -f4 -d\')
# echo "db: ${DB} user: ${USER} pass: ${PASS}  host: ${HOST}"
# exit 0
DATE=`date +%Y%m%d%H%M`

# moving to temp dir
pushd /var/tmp/ 2>&1 >/dev/null

# Dump Structure
echo "Starting to dump the table structure."
TABLES=`mysql --skip-column-names -e 'show tables' -u ${USER} -p${PASS} -h ${HOST} ${DB}`
mysqldump --complete-insert --disable-keys --single-transaction --no-data -u ${USER} --password=${PASS} -h ${HOST} ${DB} ${TABLES} > ${DB}.${DATE}.sql

# Dump Data, Excluding Certain Tables
echo "Starting to dump the table data."
TABLES2=`echo "$TABLES" | grep -Ev "^(accesslog|cache.*|flood|search_.*|semaphore|sessions|watchdog)$"`
mysqldump --complete-insert --disable-keys --single-transaction --no-create-info -u ${USER} --password=${PASS} -h ${HOST} ${DB} ${TABLES2} >> ${DB}.${DATE}.sql

echo "Starting to gzip dump."
gzip -v ${DB}.${DATE}.sql

popd 2>&1 >/dev/null
echo "Done!"