Automated Drupal DB Pull from the server with Drush sql-dump

automated_db_pull.sh

#!/usr/bin/env bash

# This script can be run from any location.
# - sh automated_dbpull.sh

# SSH to the server using SSH key.
ssh -tt -i ~/.ssh/id_rsa YOURUSERNAME@SERVER << EOF
	cd /var/www/sites/SITEDIRECTORY/www;
	drush sql-dump --result-file=../build/DBNAMEOFCHOICE.sql --gzip --structure-tables-key=cache,cache_*,history,search_*,sessions,watchdog;
	exit;
EOF
echo "Exited SSH";
scp YOURUSERNAME@SERVER:/var/www/sites/SITEDIRECTORY/build/DBNAMEOFCHOICE.sql.gz ~/Sites/LOCALSITE/build/ref_db;
echo "DB downloaded."