Backup MySQL database from the docker container to the output SQL file

makeDatabaseBackup.sh

#!/bin/bash
# REQUIRES ROOT ACCESS TO DUMP ALL THE PROCEDURES TRIGGERS ETC.

source .env

DATE_TIME=$(date +%Y-%m-%d__%H_%M_%S)

BACKUP_FILE="${DB_DATABASE}_backup_${DATE_TIME}.sql"

docker exec project-mysql_database-1 mysqldump -h $DB_HOST -u root -p"$DB_ROOT_PASSWORD" $DB_DATABASE  --single-transaction --routines --triggers > $BACKUP_FILE

echo "Backup of the database saved as $BACKUP_FILE"

docker ps will tell you how your database container is named