#!/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
Linux命令行与shell脚本(20)--实例:备份文件
04-25 阅读数 3249
创建一个配置文件,该文件包含了要备份的每个目录或文件$catfiles_backup_config/Users/chenhong/Desktop/shell_workspace/mysql.sh/Us... 博文 来自: ch717828的专栏