shell脚本实现mysql 数据库备份

#!/bin/bash
 
DATA_PATH=/data/mysql/DBbakup
BAK_DATE=$(date "+%Y%m%d")
RM_DATE=$(date -d '-90 days' "+%Y%m%d")
MYSQL_HOME=/usr/local/mysql/bin
DB=campus-map-kmykdx
IP=127.0.0.1
PORT=3306
USER=root
PWD=******
 
#目录不存在，则创建
[ ! -d "$DATA_PATH" ] && mkdir -p "$DATA_PATH"
 
echo "bakup mysql data ${DB}: "${DATA_PATH}/${DB}_${BAK_DATE}.sql.gz
${MYSQL_HOME}/mysqldump -h ${IP} -P ${PORT} -u ${USER} --password=${PWD} -R -E \
--databases ${DB} | gzip > ${DATA_PATH}/${DB}_${BAK_DATE}.sql.gz
 
echo "delete old dateAt ${RM_DATE} data: "${DATA_PATH}/${RM_DATE}.sql.gz
rm -f ${DATA_PATH}/${RM_DATE}.sql.gz