一.docker启动的数据库定时备份脚本
vim mysql_data_bak.sh
#!/bin/bash
mysql_user="root"
mysql_password="123456"
mysql_host="localhost"
mysql_port="3306"
mysql_charset="utf8mb4"
mkdir -p /usr/local/mysql.bak/
backup_location=/usr/local/mysql.bak/
expire_backup_delete="ON"
expire_days=15
backup_time=`date +%Y-%m-%d-%H-%M`
backup_dir=$backup_location
docker exec -i mysql mysqldump -h$mysql_host -P$mysql_port -u$mysql_user -p$mysql_password -B dbname | gzip> $backup_dir/mysql_backup_dbname_$backup_time.sql.gz
if [ "$expire_backup_delete" == "ON" -a "$backup_location" != "" ];then
`find $backup_location/ -type f -mtime +$expire_days | xargs rm -rf`
echo -e "\033[32m #### MySQL数据库已备份 $expire_days天前的备份已删除 #### \033[0m"
fi
二.加入定时任务每天执行备份
30 3 * * * cd /docker/scripts; bash mysql_data_bak.sh &>>mysql.log
三.还原备份数据库
docker cp dbbak.sql.gz mysql:/
zcat dbbak.sql.gz | mysql -uroot -p123456