#!/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