数据库备份脚本

浏览数：14 / 时间：2015年06月12日

1.简单备份脚本：

#!/bin/bash
user="root"
pwd="HuaShang@155!"
dbs="charging"
backuppath="/root/hssy_dbback"
cd $backuppath
backupname="$dbs"_$(date +%Y-%m-%d)
mysqldump -u$user -p$pwd $dbs >$backupname.sql
if [ "$?" == "0" ]
then
  echo $(date +"%Y-%m-%d %H:%M:%S")" ============ $dbs ===========  mysqldump sucess =========">>./log/backup.log
else
  echo $(date +"%Y-%m-%d %H:%M:%S")" >++++++++++> $dbs +++++++++++> mysqldump failed ++++++++>">>./log/backup.log
  exit 0
fi

2.脚本1改进版（适合多个数据库同一脚本备份）：

由于我有两个数据库一个charging 一个charging2 ，为了方便对两个数据库备份，做了如下改进，让脚本运行的时候带入参数。这样我执行./db_backup.sh 2 就可以备份charging2了。当然还可以带入跟多参数对单个表进行备份等，留待以后研究。

ps:

$0就是脚本文件的名字,$1是第一个参数,$2为第2个...,$9以后就需要打括号了,如${10},${11},${12}...

代码如下：

#!/bin/bash
user="root"
pwd="***"

if [ "$1"=="2" ]
then
    dbs="charging2"
else
    dbs="charging"
    exit 0
fi

backuppath="/root/hssy_dbback"
cd $backuppath
backupname="$dbs"_$(date +%Y-%m-%d)
mysqldump -u$user -p$pwd $dbs >$backupname.sql
if [ "$?"=="0" ]
then
  echo $(date +"%Y-%m-%d %H:%M:%S")" ============ $dbs ===========  mysqldump sucess =========">>./log/backup.log
else
  echo $(date +"%Y-%m-%d %H:%M:%S")" >++++++++++> $dbs +++++++++++> mysqldump failed ++++++++>">>./log/backup.log
  exit 0
fi

参考:http://w55554.blog.51cto.com/947626/1132079

3.远程备份、压缩定时删除（保留一个月的记录）

#!/bin/bash
host=xxx.xxx.xxx.xxx
user="gprs"
pwd="***"
dbs="gprs"
backuppath="/home/gprs_data_backup"
day=30
#[ !-d $backuppath ]&&mkdir -p $backuppath
cd $backuppath
backupname="$dbs"_$(date +%Y-%m-%d)
mysqldump -h$host -u$user -p$pwd $dbs >$backupname.sql
if [ "$?"=="0" ]
then
   echo $(date +"%Y-%m-%d %H:%M:%S")" ============ $dbs ===========  mysqldump sucess =========">>./log/backup.log
else
   echo $(date +"%Y-%m-%d %H:%M:%S")" >++++++++++> $dbs +++++++++++> mysqldump failed ++++++++>">>./log/backup.log
   exit 0
fi
tar -czf $backupname.tar.gz *.sql
if [ "$?"=="0" ]
then
   echo $(date +"%Y-%m-%d %H:%M:%S")" ============ tar sucess =========">>./log/backup.log
else
   echo $(date +"%Y-%m-%d %H:%M:%S")" >++++++++++> tar failed +++++++++>">>./log/backup.log
   exit 0
fi
rm -f *.sql
delname=gprs_$(date -d "$day day ago" +%Y-%m-%d).tar.gz
rm -f $delname