sourceserver.info

Source code

#!/bin/bash

#General
ftp=/home/xxx/backup/ftp
sql=/home/xxx/backup/sql

#Date-String
date=`date +"%Y-%m-%d_%H-%M"`

#MYSQL
dbsuffix="_xxx.sql.bz2"
dbhost="Domain"
dbname="DatenbankName"
dbuser="DatenbankBenutzer"
dbpasswd="DatenbankPasswort"
dbparm="--quick --protocol=TCP --opt -C"

#FTP
ftpsuffix="_xxx.tar.bz2"
ftphost="FTP_Host"
ftpuser="FTP_User"
ftppasswd="FTP_Passwort"
ftpdir="$ftp/$date"
ftpremotedir="/"
ftpcmd="mirror"
ftpparm="--parallel=4 --no-umask -x usage/ -x downloads/ -x old/ -X *.sql.gz -X *.sql"

#TESTS
error=0
which lftp >/dev/null || { echo "Error: lftp not found"; error=1 ;}
which tar >/dev/null || { echo "Error: tar not found"; error=1 ;}
which bzip2 >/dev/null || { echo "Error: bzip2 not found"; error=1 ;}
which mysqldump >/dev/null || { echo "Error: mysqldump not found"; error=1 ;}
[[ -d $ftp ]] || { echo "Error: The directory $ftp from \$ftp doesn't exist"; error=1 ;}
[[ -d $sql ]] || { echo "Error: The directory $sql from \$sql doesn't exist"; error=1 ;}
[[ $error == 1 ]] && exit


#CODE
while [[ $# -gt 0 ]]; do
        case "$1" in
                "--sql")
                #sql
                mysqldump $dbparm -h $dbhost -u$dbuser -p$dbpasswd $dbname | bzip2 -c9 > $sql/${date}${dbsuffix}
                ;;

                "--ftp")
                #ftp
                mkdir $ftpdir
                lftp -u $ftpuser:$ftppasswd -e "$ftpcmd $ftpparm $ftpremotedir $ftpdir;quit" $ftphost &> /dev/null
                cd $ftp
                tar -cjf $date$ftpsuffix $date
                rm -Rf $ftp/$date
                ;;
        esac
        shift
done