backup all mysql docker containers

backup_all_mysql_containers.sh

#!/bin/bash

# to restore use:
# cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -uroot -p"$MYSQL_ROOT_PASSWORD" DATABASE

NOW=$(date +%Y-%m-%d)
WHERE=/backup/daily-mysql/

# list only running mysql containers
CONTAINERS=$(docker ps --format 'table {{.Image}} {{.Names}}' | grep mysql | awk '{print $2}')

echo "All mysql containers: "
echo $CONTAINERS

for CONTAINER in ${CONTAINERS[@]}; do
    mkdir -p $WHERE/$CONTAINER
    echo -n "Dumping $CONTAINER... "
    docker exec $CONTAINER sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' | gzip > $WHERE/$CONTAINER/$CONTAINER-$NOW.sql.gz
    echo "done!"
done

echo "All done"