Chủ Nhật, 1 tháng 4, 2012

Script backup mysql to FTP Server


#!/bin/bash
### MySQL Server Login Info ###
MUSER="triit"
MPASS="triit"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
BAK="/backup/mysql"
GZIP="$(which gzip)"
### FTP SERVER Login info ###
FTPU="triit"
FTPP="triit"
FTPS="1.2.3.4"
NOW=$(date +"%d-%m-%Y")
[ ! -d $BAK ] && mkdir -p $BAK || /bin/rm -f $BAK/*
#DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
DBS="test"
for db in $DBS
do
# FILE=$BAK/$db.$NOW-$(date +"%T").gz 
FILE=$BAK/$db.$NOW.gz
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done
lftp -u $FTPU,$FTPP -e "mkdir mysql/$NOW;cd mysql/$NOW; mput /backup/mysql/*; quit" $FTPS

Không có nhận xét nào:

Đăng nhận xét