数据备份

#!/bin/bash

#Define PATH定义变量

BAKDIR=/data/backup/mysql/`date +%Y-%m-%d`

MYSQLDB=$1

MYSQLPW=backup

MYSQLUSR=backup

MYSQL_CMD="/usr/bin/mysqldump"

#must use root user run scripts 必须使用root用户运行，$UID为系统变量

if [ $UID -ne 0 ];then

　　echo This script must use the root user ! ! !　　

　　sleep 2

　　exit 0

fi

#Define DIR and mkdir DIR 判断目录是否存在，不存在则新建

if [ ! -d $BAKDIR ];then

　　mkdir -p $BAKDIR

fi

#Use mysqldump backup Databases

if [ $MYSQLDB == "all" ];then

　　$MYSQL_CMD -u$MYSQLUSR -p$MYSQLPW --all-databases >$BAKDIR/${MYSQLDB}_db.sql

　　echo "The mysql $MYSQLDB backup successfully "

else

　　$MYSQL_CMD -u$MYSQLUSR -p$MYSQLPW $MYSQLDB >$BAKDIR/${MYSQLDB}_db.sql

　　echo "The mysql $MYSQLDB backup successfully "

fi