#!/bin/bash

mysql_host="127.0.0.1"

mysql_user="root"

mysql_passwd="********"

back_dir="/www/backup/database/"

ignore_db="information_schema|mysql|performance_schema"

db_arr=`mysql -u${mysql_user} -p${mysql_passwd} -h${mysql_host}  -Bse "show databases;" | grep -vE "(${ignore_db})"`

datetime=$(date +%Y-%m-%d-%H_%M_%S)

for dbname in ${db_arr}

do

    mysqldump -u${mysql_user} -p${mysql_passwd} -h${mysql_host} ${dbname} | gzip > ${back_dir}${dbname}-${datetime}.sql.gz

done

find ${back_dir} -mtime + -name "*.*" -exec rm -rf {} \;

#!/bin/bash

datetime=$(date +%Y-%m-%d-%H_%M_%S)

MYSQL=$(docker ps| grep "mysql:5.7" | grep -v grep | awk '{print $1}')

backup_path=/data/backup/

MYSQL_ROOT_PASSWORD=密码

docker exec ${MYSQL} sh -c "exec mysqldump --all-databases -uroot -p$MYSQL_ROOT_PASSWORD" > ${backup_path}/${datetime}_all-databases.sql

find ${backup_path} -mtime + -name "*.sql" -exec rm -rf {} \;