#! /bin/bash

cd /data/docker/mysql
 
TIMESTAMP=$(date +"%F")
BACKUP_DIR="/data/docker/mysql/backup/$TIMESTAMP"
MYSQLDUMP="docker exec mysql /usr/bin/mysqldump -u root -pazedfg"
MYSQL="docker exec mysql /usr/bin/mysql -u root -pazedfg"
 
mkdir -p "$BACKUP_DIR"
 
databases=`$MYSQL -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`
 
for db in $databases; do
  $MYSQLDUMP --force --opt --databases $db | gzip > "$BACKUP_DIR/$db.gz"
done

find /data/docker/mysql/backup* -mtime +10 -exec rm -rf {} \;