备份mysql库脚本

#!/bin/sh
thread=`ps -ef | grep mysql | grep -v grep | wc -l`
if [ $thread -gt 0 ]; then
    #删除备份文件,十天前的
    #echo "staring drop bak files"
    #find /home/chnsys -atime +1 -name "mysql_*.sql" -exec rm -rf {} \;
    #echo "bak files drop end"
    if test -r /home/chnsys/mysql_*.sql;then
        echo "bak files exist, drop files now"
        rm -rf  /home/chnsys/mysql_*.sql
    else
        echo "bak files not  exist, starting to bak mysqldb"
    fi
    echo "mysql threading exist, begin to bakground mysql"
    date=$(date "+%Y-%m-%d_%H%M%S")
    /home/chnsys/mysql5.7.17/bin/mysqldump -uroot -ppassword swdc > /home/chnsys/mysql_swdc$date.sql 
else
    echo "mysql not exist"
fi