drupal-quick-dump.sh

#!/bin/bash
# usage: drupal-quick-dump database (assumes use of .my.cnf)

DB="$1"
DATE=`date +%Y%m%d`

# Dump Structure
echo "Starting to dump the table structure."
TABLES=`mysql --skip-column-names -e 'show tables' ${DB}`
mysqldump --complete-insert --disable-keys --single-transaction --no-data ${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 ${DB} ${TABLES2} >> ${DB}.${DATE}.sql

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

echo "Done!"