1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| #!/bin/bash
mysql_user="root" mysql_password="root"
container_id='543f03622637'
backup_dir=~/docker-bak/
if [ ! -d $backup_dir ]; then mkdir -p $backup_dir fi
expire_backup_delete="ON" expire_days=7 backup_time=`date +%Y%m%d%H%M` welcome_msg="Welcome to use MySQL backup tools!"
docker exec ${container_id} mysqldump -u${mysql_user} -p${mysql_password} -A > ${backup_dir}/alldb-${backup_time}.sql
删除过期数据 if [ "$expire_backup_delete" == "ON" -a "$backup_dir" != "" ];then `find $backup_dir/ -type f -mtime +$expire_days | xargs rm -rf` echo "Expired backup data delete complete!" fi
|