1、
2、
#!/bin/bash
date_str=$(date +_%Y_%m_%d_%H_%M_%S.sql.gz)
echo '开始备份数据'$date_str
#获取容器id
mysqlid=`docker ps -aqf "name=mysql57"`
#进入mysql容器
docker exec -i ${mysqlid} /bin/bash<<'EOF'
mysqldump -hlocalhost -uroot -p"password" -E -R dbname | gzip > /var/lib/mysql/db_backup/dbname$(date +_%Y_%m_%d_%H_%M_%S.sql.gz)
echo '成功备份数据'
if [ $? -ne 0 ]; then
echo 'mysqldump运行失败'
exit
EOF
fi
exit
EOF
cp -u /www/opt/mysql/data/db_backup/* /www/opt/aaaaa/db_backup/
echo '拷贝完成'
cd /www/opt/aaaaa/db_backup
file_name_new=$(ls -lt | head -n 2 | tail -n 1 | awk '{print $9}')
echo $file_name_new
cd /root/tools/ossutil/ && ./ossutil64 cp -r /www/opt/aaaaa/db_backup/$file_name_new oss://xxxxx-blck/deployment_temp_files/bbbbbb/db_back/ --update --disable-all-symlink
标签:www,db,echo,获取,拷贝,docker,backup,_%
From: https://www.cnblogs.com/kikyoqiang/p/17863483.html