SQL Dump

gistfile1.sh

# While inside a drupal site directory creates a SQL backup with the name of the site's directory and the current date.
drush sql-dump | gzip > ~/SQL-Backup/${PWD##*/}.$(date +%y%m%d).gz

# More advanced example:
# From the `drupal/sites` directory do a SQL backup of all the sites available
for dir in $(ls | egrep -v 'all|default'); do
  if [ -d $dir ]; then
    cd $dir
    echo "Backup of site: $dir"
    drush sql-dump | gzip > ~/SQL/${pwd##/}.$(date +%Y-%m-%d).gz
    cd ..
  fi
done

# ..or in one line:
for dir in $(ls | egrep -v 'all|default'); do if [ -d $dir ]; then cd $dir; echo "Backup of site: $dir"; drush sql-dump | gzip > ~/SQL/${pwd##/}.$(date +%Y-%m-%d).gz; cd ..; fi; done;