Script to dump Drupal database structure, but exclude data from massive/unneeded tables.

drupal-quick-dump.sh

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

USER="$1"
HOST="$2"
DB="$3"
DATE=`date +%Y%m%d`

# Get User Password
echo "Please provide the password for ${USER} on db ${DB} hosted at ${HOST}:"
read -se PASS

# 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

echo "Done!"

Need to put double quotes around ${PASS}, so that passwords with spaces can work.

I'm working on an update to handle passwords with spaces... just adding quotes didn't work.

Here's the fix for the problem with spaces:
https://gist.github.com/webbj74/3852713

You should be able to add my commits if you:

$ git clone https://gist.github.com/3852923.git drupal-quick-dump
$ cd drupal-quick-dump
$ git remote add webbj74 https://gist.github.com/3852713.git
$ git merge webbj74/master
# fix any conflicts & commit
$ git push