mysql备份数据

vim auto_back_mysql.sh
#!/bin/bash
#auto backup mysql DB
#by author jfedu.net 2016
MYSQL_CMD="/usr/bin/mysqldump"
MYSQL_USR="root"
MYSQL_PWD="123456"
MYSQL_DB="discuz"
BAK_DIR="/data/backup/`date +%Y%m%d`"
#######
if [ ! -d $BAK_DIR ]; then
   mkdir -p $BAK_DIR
else
   echo "The $BAK_DIR is exist."
fi
################
$MYSQL_CMD -u$MYSQL_USR -p$MYSQL_PWD $MYSQL_DB >

$MYSQL_DIR/discuz.sql
if [ $? -eq 0 ];then
echo -e "\033[32mThe Mysql $MYSQL_DB Backup success,Path

$BAK_DIR/${MYSQL_DB}.sql\033[0m"
else
echo -e "\033[32mThe Mysql $MYSQL_DB Backup failed,please

check.\033[0m"
fi

授权使用者
mysql -uroot -p123456
GRANT all ON *.* to root@'localhost' identified by "123456";
flush privieleges;
eixt

30天的备份文件删除
find $BAK_DIR -name "*.sql" -type f -mtime +30 -exec r
m -rf {} \;