shell脚本备份MYSQL数据库
#!/bin/bash#auto backup mysql
#by colin 2015-03-21
#define path
BAK_DIR=/data/backup/`date +%Y%m%d`/#备份的文件夹
MYSQL_USR=root#用户名
MYSQL_PW= #密码
MYSQL_DB=studya #数据库名
MYSQL_CMD=/usr/bin/mysqldump#全路径的命令
FILES=studya.sql#备份文件的名称
echo -e "\033[32m------------------------------------------\033[1m"
echo "The scripts now starting,Please wait......"
sleep 5
if [ $UID -ne 0 ];then
echo "This scripts must to be use root user."
exit 0
fi
if [ ! -d $BAK_DIR ];then
echo "备份文件夹不存在，将新建"
mkdir -p $BAK_DIR
else
echo "备份文件夹存在，将备份数据库"
fi
$MYSQL_CMD -u$MYSQL_USR -p$MYSQL_PW $MYSQL_DB > $BAK_DIR$FILES
if [ $? -eq 0 ];then
echo "数据库备份成功！"
else
echo "数据库$MYSQL_DB备份失败……"
fi
echo "Done."
页:
[1]