# 配置参数（开始）===

ymd=$(date +%Y%m%d)
echo "日期：$ymd"
echo
keepday=5
echo "保留最近天数：$keepday"
echo
dirsync="/package/autosync/sync"
echo "同步目录：$dirsync"
echo
dbname="abc"
echo "数据库：$dbname"
echo
mysqldump="/usr/bin/mysqldump"
echo "mysqldump目录：$mysqldump"
echo
dbconn="-uroot -pStrong@123@Password"
echo "数据库连接字符串：$dbconn"
echo

# 配置参数（结束）===

echo
echo "清理同步目录 $keepday 天前的备分文件"
find ${dirsync} -mtime +$keepday -name "*.zip" | xargs -I {} rm -rf {}
find ${dirsync} -mtime +$keepday -name "*.gz" | xargs -I {} rm -rf {}
echo
echo "开始备份数据库：$dbname"
backcmd="$mysqldump $dbconn $dbname --no-tablespaces > /tmp/${dbname}_$ymd.sql"
echo "$backcmd"
eval $backcmd
echo
echo "完成备份"
echo
echo "开始打包"
zip -r -q -o /tmp/${dbname}_${ymd}.zip /tmp/${dbname}_${ymd}.* -P123456789
echo
echo "移动压缩包"
mv /tmp/${dbname}_${ymd}.zip ${dirsync}
echo
echo "清理备份文件：/tmp/${dbname}_$ymd.*"
rm -f /tmp/${dbname}_${ymd}.*
echo
echo "Done"
echo