#!/bin/bash

mysqldump=1  #####создавать дамп всех бд 1 — да; 0 — нет
filedump=1 #####создавать бекап всех файлов 1 — да; 0 — нет
upload=1 #### загружать на удалённый сервер? 1 — да; 0 — нет
user="bortnik"
remotehost="emobort.loseyourip.com" #куда загружать бекапы, работает только если upload = 1
dir="/home/bortnik/backups/version3/`date +%d.%m.%Y`" #директория куда загружать бэкапы


####создание дампа всех БД
USER="root"  #юзер
PASSWORD="Galaxys7edge" #пароль
OUTPUT="/backup/`date +%d.%m.%Y`"   #путь куда создаются дампы.





#####################do not editcode bellow#####################

# check root permissions
if [ "x$(id -u)" != 'x0' ]; then
    echo 'Error: this script can be executed only by root'
    exit 1
fi

echo -e "\n" >> /var/log/$0.log
echo -e "\n" >> /var/log/$0.log
echo -e "\n" >> /var/log/$0.log

echo  >> /var/log/$0.log
echo -e "\e[42m============================$(date +'%d-%b-%Y %R')=========================\e[0m"  >> /var/log/$0.log
echo -e "\e[42m==================================START===============================\e[0m"  >> /var/log/$0.log

sleep 3

# Create directory if not exist
if [[ ! -d $OUTPUT && ! -L $OUTPUT ]]; then
mkdir -p $OUTPUT && cd $OUTPUT
fi



if [ $mysqldump = "1" ]; then

databases=`mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != _* ]] ; then

       mysqldump --routines --skip-add-locks --user=$USER --password=$PASSWORD --databases $db  > $OUTPUT/$db.sql;
       echo -e "Dump \e[34m$db\e[0m was successfully created and located here: \033[1m\e[34m $OUTPUT/$db.sql\e[0m\033[0m"   >> /var/log/$0.log


fi
      done
fi

sleep 4

#create filedump
if [ $filedump = "1" ]; then
echo -e "Creating \e[34mserver_backup.tar.gz\e[0m has started. Log of this operation is not included." >> /var/log/$0.log
sleep 1
echo -e "\n"  >> /var/log/$0.log
cd $OUTPUT && tar cvpzf server_backup.tar.gz --exclude=/ztmp --exclude=/proc --exclude=/ztemp --exclude=/media --exclude=/mnt --exclude=/opt --exclude=/srv --exclude=/tmp --exclude=$OUTPUT/server_backup*.tar.gz --exclude=/backup --one-file-system /
echo -e "Dump \e[34mserver_backup.tar.gz\e[0m was successfully created and located here: \033[1m\e[34m $OUTPUT/$db.sql\e[0m\033[0m"  >> /var/log/$0.log
else
echo -e "\n"  >> /var/log/$0.log
echo -e "Сreating \e[34mserver_backup.tar.gz\e[0m is not enabled"  >> /var/log/$0.log
fi


sleep 3


# Create directory if not exist in remote host and upload backup
if [ $upload = "1" ]
then
ssh $user@$remotehost 'dir="'"$dir"'"; test -d "$dir" || mkdir -p "$dir"'
 rsync -avzh --progress --remove-source-files -W $OUTPUT/*.tar.gz $user@$remotehost:$dir
 sleep 1
 echo -e "\n"  >> /var/log/$0.log
 echo -e "\e[34mserver_backup.tar.gz\e[0m was successfully upload to your remote host."  >> /var/log/$0.log
 sleep 2
 rsync -avzh --progress --remove-source-files -W $OUTPUT/*.sql $user@$remotehost:$dir
 echo -e "\e[34msql-files\e[0m was successfully upload to your remote host."  >> /var/log/$0.log
else
echo -e "Uploading to remote is not enabled"  >> /var/log/$0.log
fi

echo  >> /var/log/$0.log
echo -e "\e[42m============================$(date +'%d-%b-%Y %R')=========================\e[0m"  >> /var/log/$0.log
echo -e "\e[42m===================================END===============================\e[0m"  >> /var/log/$0.log