[root@bogon ~]# cat auto_backup_mysql.sh

#!/bin/bash

#auto backup mysql db

#by authors wugk

#define backup path

BAK_DIR=/data/backup/`date +%Y%m%d`

MYSQLDB=cacti

MYSQLUSR=backup

MYSQLPW=

MYSQLCMD=/usr/bin/mysqldump

if [ $UID -ne  ];then

    echo "Must to be use root for exec shell."

    exit

fi

if [ ! -d $BAK_DIR ];then

    mkdir -p $BAK_DIR

    echo -e "\033[32mThe $BAK_DIR Create Successfully!\033[0m"

else

    echo "This $BAK_DIR is exists..."

fi

#Mysql BACKUP COMMAND

$MYSQLCMD -u$MYSQLUSR -p$MYSQLPW -d $MYSQLDB > $BAK_DIR/$MYSQLDB.sql

if [ $? -eq  ];then

    echo -e "\033[32mThe Mysql Backup $MYSQLDB Successfully!\033[0m"

else

    echo -e "\033[32mThe Mysql Backup $MYSQLDB Failed, please check.\033[0m"

fi