#!/bin/bash
#For Backup Mysql
#Date:XXX
DOCKERNAME=”dockernames”
USER=”xx”
PASS=”xx”
MYSQL_BAKDIR=”/data/mysqlback/”
MYSQL_DIR=”/data/mysqlback/
date +%Y%m%d”
function CMD()
{
docker exec ${DOCKERNAME} mysqlshow -u${USER} -p${PASS}
return 0
}
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