#!/bin/sh

##VARIABLES
MYSQLDUMP="$(which mysqldump)"
USER_DIR='/var/www/clients/client3/web13'

## MYSQL
DB_HOST='db.openet.hosting'
DB_USER='dbu_3_admin'
DB_PASS='hokvgWHZEK20_'
DB_NAME='db_3_new'

#STORAGE
DIR_WEB="$USER_DIR/web"
DIR_PRIV="$USER_DIR/private"
DIR_BAK="$DIR_PRIV/backup"

if [ ! -d $DIR_BAK ]; then
    mkdir -p $DIR_BAK;
fi;

tar -cf $DIR_BAK/files.tar $DIR_WEB
$MYSQLDUMP -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_NAME | gzip> $DIR_BAK/$DB_NAME-backup.sql.gz

tar -cf $DIR_PRIV/backup.tar $DIR_BAK && gzip -r9 -f $DIR_PRIV/backup.tar

sleep 10
rm -rf $DIR_BAK