#!/bin/bash
########################
#
# MysqL auto backup
#
########################
 
BACKUPDIR=/opt/bee/shtest/data/` date +%Y-%m-%d `   #数据库备份路径
MysqLDB=nowcoder                                    #要备份的数据库名
MysqLUSR=root                                       #用户名
 
#must use root user run scripts
if
  [ $UID -ne 0 ];then
  echo "This script must use the root user"
  sleep 2
  exit 0
fi
 
if
 [ ! -d $BACKUPDIR ];then
 mkdir -p $BACKUPDIR
else
 echo "$BACKUPDIR exists ..."
fi
 
echo "Please input passwd:"
read -s  passwd
MysqLPW=$passwd                  #密码
# use MysqLdump backup MysqL
echo -e  $MysqLPW
/usr/bin/MysqLdump -u$MysqLUSR -p$passwd -d $MysqLDB >$BACKUPDIR/nowcoder.sql
 
cd $BACKUPDIR; tar -czf  ${MysqLDB}_db.tar.gz *.sql
 
#删除备份目录下以.sql结尾的文件并删除
find . -type f -name *.sql |xargs rm -rf
 
#备份成功打印提示
[ $? -eq 0 ] && echo "This `date +%Y-%m-%d` MysqL backup success"
 
cd $BACKUPDIR ; find . -type d -mtime +30 | xargs rm -rf