mysql数据库备份脚本_mysql数据库备份脚本

#!/bin/bash

# 作者:龙力勤

# 出自懒人运维:http://www.lazysa.com

# 用途:mysql数据库备份脚本。

# 表述:该脚本可以将数据库备份到/backup目录，以便你随时恢复备份。

# 同时该脚本可以指定你要备份的数据库。

# 更多关于此脚本的讨论，请参考:

# http://www.lazysa.com/2009/08/758.html

# 最新更新:2009-08

MyUSER=”SET-MYSQL-USER-NAME”     # USERNAME

MyPASS=”SET-PASSWORD”       # PASSWORD

MyHOST=”localhost”          # Hostname

# Linux bin paths, change this if it can’t be autodetected via which command

MYSQL=”$(which mysql)”

MYSQLDUMP=”$(which mysqldump)”

CHOWN=”$(which chown)”

CHMOD=”$(which chmod)”

GZIP=”$(which gzip)”

# Backup Dest directory, change this if you have someother location

DEST=”/backup”

# Main directory where backup will be stored

MBD=”$DEST/mysql”

# Get hostname

HOST=”$(hostname)”

# Get data in dd-mm-yyyy format

NOW=”$(date +”%d-%m-%Y”)”

# File to store current backup file

FILE=”"

# Store list of databases

DBS=”"

# DO NOT BACKUP these databases

IGGY=”test”

[ ! -d $MBD ] && mkdir -p $MBD || :

# Only root can access it!

$CHOWN 0.0 -R $DEST

$CHMOD 0600 $DEST

# Get all database list first

DBS=”$($MYSQL -u $MyUSER -h $MyHOST -p$MyPASS -Bse ‘show databases’)”

for db in $DBS

do

skipdb=-1

if [ "$IGGY" != "" ];

then

for i in $IGGY

do

[ "$db" == "$i" ] && skipdb=1 || :

done

fi

if [ "$skipdb" == "-1" ] ; then

FILE=”$MBD/$db.$HOST.$NOW.gz”

# do all inone job in pipe,

# connect to mysql using mysqldump for select mysql database

# and pipe it out to gz file in backup dir

$MYSQLDUMP -u $MyUSER -h $MyHOST -p$MyPASS $db | $GZIP -9 > $FILE

fi

done

觉得文章有用？立即：

和朋友一起 共学习 共进步！

猜您喜欢