#!/bin/bash

 

#Fileserver Backup Script

 

SSH_USER=

SSH_PW=

SSH_HOST=

 

#Installed needed tools

for i in /usr/bin/lftp

do

        if [ -e $i ]

        then

                echo "ok lftp found"

        else

                apt -y install lftp

        fi

done

 

for e in /usr/bin/rsync

do

        if [ -e $e ]

        then

                echo "ok rsync found"

        else

                apt -y install rsync

        fi

done

 

for g in /usr/bin/sshpass

do

        if [ -e $g ]

        then

                echo "ok sshpass found"

        else

                apt -y install sshpass

        fi

done

 

#Workround

mkdir -p /home/MYSQL-BACKUPS/public_html

 

for D in $(find /var/lib/mysql -mindepth 1 -maxdepth 1 -type d) ; do

    echo ${D##*/}

    mysqldump -u root ${D##*/} > /home/MYSQL-BACKUPS/${D##*/}.sql

    gzip /home/MYSQL-BACKUPS/${D##*/}.sql

    echo '';

done

 

rm /home/MYSQL-BACKUPS/modsec.sql -f

 

#Yesterdays date in ISO-8601 format:

DAY1=`date -d "yesterday 13:00" '+%Y-%m-%d'`

 

#Todays date in ISO-8601 format:

DAY0=`date -I`

 

lftp sftp://${SSH_USER}:${SSH_PW}@${SSH_HOST}  -e "mkdir -p media/host/backup__$DAY0/home/MYSQL-BACKUPS; bye"

 

/usr/bin/sshpass -p "$SSH_PW" /usr/bin/rsync -avhi -e 'ssh -o StrictHostKeyChecking=no -p 23' --link-dest /home/MYSQL-BACKUPS/ /home/MYSQL-BACKUPS/ "$SSH_USER"@$SSH_HOST:media/host/backup__$DAY0/home/MYSQL-BACKUPS/

 

for F in $(find /home/ -mindepth 1 -maxdepth 1 -type d) ; do

 

    echo $F

 

    lftp sftp://${SSH_USER}:${SSH_PW}@${SSH_HOST}  -e "mkdir -p media/host/backup/home_backup__$DAY0$F; bye"

 

    #The source directory:

    SRC="$F/public_html/"

 

    #The target directory:

    TRG="$SSH_USER@$SSH_HOST:media/host/backup/home_backup__$DAY0$F/"

 

    #The link destination directory:

    LNK="$SRC"

 

    echo /usr/bin/sshpass -p "$SSH_PW" /usr/bin/rsync -avhi $LNK -e 'ssh -o StrictHostKeyChecking=no -p 23' --link-dest $LNK $SRC $TRG

    /usr/bin/sshpass -p "$SSH_PW" /usr/bin/rsync -avhi -e 'ssh -o StrictHostKeyChecking=no -p 23' --link-dest $LNK $SRC "$SSH_USER"@"$SSH_HOST:media/host/backup/home_backup__$DAY0$F/"

done