Снимает дампы и заливает на фтп сервак
Код: Выделить всё
#!/bin/bash
# Shell script to backup MySql database
# To backup Nysql databases file to /backup dir and later pick up by your
# script. You can skip few databases from backup too.
#
# Linux bin paths, change this if it can not be autodetected via which command
# Requirements:
# ncftp 3 client
# Binaries
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
CHOWN="$(which chown)"
CHMOD="$(which chmod)"
GZIP="$(which gzip)"
NCFTP="$(which ncftpput)"
TAR="/bin/tar" # must be gnu tar
# Your Data
MUSER="username" # USERNAME
MPASS="password" # PASSWORD
MHOST="localhost" # Hostname
FTPH="ftp.backup.com" # Remote ftp user name
FTPU="ftpusername" # Remote ftp user password
FTPP="ftppassword" # Remote directory, blank for default remote dir
# If dir does not exist it will be created automatically by ncftpput :)
FTPD="backup/$(date +"%d-%m-%Y")" # Backup Dest directory, change this if you have someother location
BACKUP="/srv/backup" # Backup Dest dir
# Get data in dd-mm-yyyy format
NOW="$(date +"%d-%m-%Y")"
DBFOLDER="${BACKUP}/${NOW}" # Maybe keep backups on $NOW dir?
# Get hostname
HOST="$(hostname)"
# File to store current backup file
FILE=""
# Store list of databases
DBS=""
[ ! -d $DBFOLDER ] && mkdir -p $DBFOLDER || :
# Get all database list first
DBS="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
# Backuping
for db in $DBS
do
FILE=${DBFOLDER}/$db.$HOST.$(date +"%d-%m-%Y_%H").gz
echo Backuping $db database... # Maybe need check for db backup?
$MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS $db | $GZIP -9 > $FILE
done
# Uploading files to FTP server
FILES="$($MYSQL -u $MUSER -h $MHOST -p$MPASS -Bse 'show databases')"
for file in $FILES
do
DEST=${DBFOLDER}/$file.$HOST.$(date +"%d-%m-%Y_%H").gz
echo Uploading $DEST to FTP Server...
$NCFTP -m -u "$FTPU" -p "$FTPP" "$FTPH" "$FTPD" "$DEST"
OSTAT="$?"
case $OSTAT in
0) MESS="Success.";;
1) MESS="Could not connect to remote host $FTPH.";;
2) MESS="Could not connect to remote host $FTPH - timed out.";;
3) MESS="Transfer failed.";;
4) MESS="Transfer failed - timed out.";;
5) MESS="Directory change failed.";;
6) MESS="Directory change failed - timed out.";;
7) MESS="Malformed URL.";;
8) MESS="Usage error. May be your version of ncftpput ($NCFTP) is old";;
9) MESS="Error in login configuration file.";;
10)MESS="Library initialization failed.";;
11) MESS="Session initialization failed.";;
*) MESS="Unknown error, contact admin $ADMIN_INFO";;
esac
done
