Drupal - Backup DB using Drush

d8-backup-db.sh

#!/bin/bash

# staging or production
DB_ENV="staging"

##### DO NOT EDIT FROM HERE #####

# Find the container
CONTAINER="$(docker ps  | grep c-${DB_ENV} | awk '{print $1}')"

# Timestamp (used to build dump filename)
DATE=$(date +"%Y%m%d%H%M%S")

# Dump filename
DUMP_FILENAME="sigel_${DB_ENV}_${DATE}.sql"

# Export the DB
docker exec -w /var/www/html ${CONTAINER} drush sql-dump --gzip --structure-tables-key=common --result-file=/tmp/${DUMP_FILENAME}

# Move the dump to the backups folder
mv /tmp/${DUMP_FILENAME}.gz ~/backups/${DB_ENV}/${DUMP_FILENAME}.gz