mysql_do_backup.sh

#!/bin/bash
TIMESTAMP=`date +"%Y-%m-%d %H.%M.%S"`
FILENAME="Backup Name $TIMESTAMP.sql.gz"
BAK_PATH="$HOME/bak"
mysqldump -u user --password=`cat ~/some/path/.env | grep DB_PASSWORD | sed 's/DB_PASSWORD=//'` your_db_name | gzip > "$BAK_PATH/$FILENAME"
echo $FILENAME > "$BAK_PATH/latest_backup"

mysql_docker_do_backup.sh

#!/bin/bash
BAK_PATH="$HOME/bak"
TIMESTAMP=`date +"%Y-%m-%d_%H.%M.%S"`
FILENAME="BAK_name_$TIMESTAMP.sql.gz"
echo Making backup $FILENAME
docker compose -f ~/your/path/compose.yaml exec -T database mysqldump -u user --password=`cat ~/your/path/config/mariadb/.env | grep MARIADB_PASSWORD | sed 's/MARIADB_PASSWORD=//'` db_name | gzip > "$BAK_PATH/$FILENAME"
echo $FILENAME > "$BAK_PATH/latest_backup"