mysqldump 备份数据库脚本

mysqldump 备份mysql数据库 并压缩为bz2 

#!/bin/bash

#program
#this scrpt is for the full backup of the  database
#history
#2016/12/7  lilei frist release
USER=root
PASSWD=123456
BACKPATH=/mydata/backup
BACKFILE=$(date +%F-%H-%M-%S)
if [ ! -d ${BACKPATH} ]; then
        echo " this directory is not exits! please  create ${BACKPATH}  directory! "
        mkdir -v -p -m=rwxrr ${BACKPATH}
        if [ $? == 0 ]; then

                echo " create  directory success!!"

                #perform full backup

                mysqldump -u${USER}  -p${PASSWD} urionzp2p --opt |bzip2  > ${BACKPATH}/${BACKFILE}.sql.bz2
                if [ $? -eq 0 ]; then
                        echo " test database backup success!!"
                else
                        echo " test databsae backup failed!!"
                fi
        else
                echo " create  directory  failed !! "
        fi
else


                #perform full backup
                mysqldump -uroot  -pxbddai8823xbd urionzp2p --opt |bzip2 > ${BACKPATH}/${BACKFILE}.sql.bz2
                if [ $? -eq 0 ]; then
                        echo " test database backup success!!"
                else
                        echo " test databsae backup failed!!"
                fi
fi
~