MySQL数据库冷备脚本

将该脚本放到可运行mysqldump客户端的主机上，还需要在数据库上配置备份和权限，配合完毕后添加定时任务运行即可

先root登录数据库进行用户创建及权限配置
其中对mysqldump 所需要的权限说明：
- 对于table 来说mysqldump 最少要有select 权限。
- 对于view 来说mysqldump 要有show view 权限。
- 对于trrigger 来说mysqldump 要有trriger 权限。
- 如果要产生一份一致的备份，mysqldump 要有lock tables 权限。

```
create user 'backuser'@'localhost' identified by ']+cwpdCWy.8~ee>7P)AJ*';
grant select on *.* to 'backuser'@'localhost';
grant show view on *.* to 'backuser'@'localhost';
grant lock tables on *.* to 'backuser'@'localhost';
grant trigger on *.* to 'backuser'@'localhost';
grant process on *.* to 'backuser'@'localhost';
```

数据库备份脚本源码:
```
#!/bin/bash
user='backuser'
pwds=']+cwpdCWy.8~ee>7P)AJ*'
host='localhost'
port='53306'
#多个db之间使用空格分隔
dbname='db1 db2 db3'
backdir='/data/storage/mysql/mysqldump'
expiretime='30'
date=`date +%Y_%m_%d-%H:%M:%S`
test ! -d "$backdir/logs" && mkdir $backdir/logs
for i in $dbname;do
        /data/mysql/basedir/bin/mysqldump -h$host -P$port -u$user -p$pwds $i > $backdir/DBbackup-$date-$i-mysql.sql
        if [[ -s "$backdir/DBbackup-$date-$i-mysql.sql" ]];then
                echo "[INFO] mysql cold backup data is completed, backupFile: $backdir/DBbackup-$date-$i-mysql.sql backupTime: $date ." >> $backdir/logs/mysqlbak_"$(date +%Y_%m_%d)".log
        else
                echo "[ERROR] mysql cold backup data is faild, faildFile: $backdir/DBbackup-$date-$i-mysql.sql faildTime: $date ." >> $backdir/logs/mysqlbak_"$(date +%Y_%m_%d)".log
        fi
done
find $backdir/DBbackup-* -type f -mtime +$expiretime -exec rm {} \;
```
添加定时任务：
其中
`data/mysql/backupScript`为脚本存放路径 ;`mysql_bakcup_script.sh`为脚本名

```
0 3 * * * /usr/bin/bash /data/mysql/backupScript/mysql_bakcup_script.sh >/dev/null 2>&1
```