#!/bin/bash
# mysql backup script
# Author: sharad
# 4-Sept-2013
#

### 提供数据库用户名,密码,备份的数据库名称
MYSQLUSER=Mysql-user
PASSWORD=Mysql-user-Passw0rd
DBNAME=Database-Name

### 提供MYSQL服务器IP地址或FQDN，例如 127.0.0.1 or localhost
MYSQLHOST=127.0.0.1

BACKUPPATH=/root/database-backup/$DBNAME-`date +%F-%H%M%S`

#你可以使用多个电子邮件，但必须用（,）分开，例如 MAILTO=abc@example.com,xyz@example.com

MAILTO=your-emailid@example.com,your-emailid@example.com

mysqldump -h$MYSQLHOST -u$MYSQLUSER -p$PASSWORD $DBNAME > $BACKUPPATH-h$MYSQLHOST -u$MYSQLUSER -p$PASSWORD $DBNAME > $BACKUPPATH

### 压缩文件 ### compressing the file 
gzip $BACKUPPATH

FILESIZE=$( du -sh $BACKUPPATH.gz )=$( du -sh $BACKUPPATH.gz )

if [ ! -f  $BACKUPPATH.gz ]; thenif [ ! -f  $BACKUPPATH.gz ]; then
    echo "$BACKUPPATH.gz File not found!, Database Name: $DBNAME" | mail -s "$DBNAME backup failed" $MAILTO"$BACKUPPATH.gz File not found!, Database Name: $DBNAME" | mail -s "$DBNAME backup failed" $MAILTO
elseelse
    echo "$BACKUPPATH.gz File found,Database Name: $DBNAME, Actual size after compression is $FILESIZE " | mail -s "DBNAME database backup is done" $MAILTO"$BACKUPPATH.gz File found,Database Name: $DBNAME, Actual size after compression is $FILESIZE " | mail -s "DBNAME database backup is done" $MAILTO
fifi