基于dockerMysql的shell备份脚本

function DEL()
{
find ${MYSQL_BAKDIR} -type d -name date +"%Y%m%d" -d "-7 days"|xargs rm -rf
return 0
}

function DUMP()
{
docker exec ${DOCKERNAME} mysqldump -u${USER} -p${PASS} ${1}
echo ${1}
return 0
}

if [ ! -d ${MYSQL_DIR} ];then
mkdir ${MYSQL_DIR} -p
fi
for i in CMD
do
echo $i|grep -qnviE ‘-|+|||schema|Databases‘ && DUMP ${i}|gzip > ${MYSQLDIR}/${i}$(date +%F).sql.gz && if [ -f ${MYSQLDIR}/${i}$(date +%F).sql.gz ];then
echo -e "date \ndump success" >> /mysqlback.log
else
echo -e "date \ndump failed" >> /mysqlback.log
fi
done
DEL

基于dockerMysql的shell备份脚本

原文：http://blog.51cto.com/13958766/2171941