Skip to content

Instantly share code, notes, and snippets.

@webbj74
Last active October 29, 2023 10:10
Show Gist options
  • Save webbj74/3852713 to your computer and use it in GitHub Desktop.
Save webbj74/3852713 to your computer and use it in GitHub Desktop.
Script to dump Drupal database structure, but exclude data from massive/unneeded tables.
#!/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} --password="${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!"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment