mysql数据库备份的shell脚本

分享一个mysql数据库备份的shell脚本

下载地址:[mysql数据库备份shell脚本](http://image.gwalker.cn/Uploads_ArticleFiles_20140820_53f478930099f.rar "mysql数据库备份shell脚本")
```shell
#!/bin/bash
#author gongwen
#email bestphper@126.com
if [ $1 = '--help' ];then
echo '[The parameter order as] 
1)the mysqldump command file path 2)MySQL user 3)MySQL password 4)to back up dbname 5)backup to directory backup 6)backup to file name

[Note]
if you want to backup database the fourth parameter to "--all-databases"

[Example]
./backup_mysql.sh "/usr/bin/mysqldump" "root" "123456" "--all-databases" "/home/mysql/backup" "dbbackup"$(date "+%Y%m%d%H%M%S")".sql"'
else
#检查参数是否输入完整
if [ ! $1 ] || [ ! $2 ] || [ ! $3 ] || [ ! $4 ] || [ ! $5 ] || [ ! $6 ];then
echo 'parameters error'
else
#备份目录
BackupPath="$5"
#备份文件名
BackupFile="$6"
#mysqldump命令文件
MysqldumpFile="$1"

#数据库的用户名及密码
user="$2"
passwd="$3"

#检查备份目录是否存在
if !(test -d $BackupPath) then
 mkdir -p $BackupPath
fi

#使用mysql提供的mysqldump备份脚本
$MysqldumpFile -u$user -p$passwd --events --ignore-table=mysql.events $4  > "$BackupPath"/"$BackupFile"
if [ $? != 0 ]; then
echo 'backup error'
else
echo 'backup success'
fi
fi
fi
```