#!/bin/bash

USER=root
PASSWORD=pass
AVUI=$(date +%d-%m-%Y)
AVUI_HORA=$(date +%d-%m-%Y_%H:%M)
BACKUP_SERVER=188.165.192.164
BACKUP_LOGIN=shimi

DIR_TO_BACKUP="/home/"
DIRECTORI_DB="/backup/databases/"
DIRECTORI_HOME="/backup/home_backup/"

DIRECTORI_DB_CHANGES="/backup/changes/databases/"
DIRECTORI_HOME_CHANGES="/backup/changes/home_backup/"

echo "-------------------------"
echo "Dumpejant bases de dades:"
echo "-------------------------"
echo ""

# llistem les bases de dades del sistema
databases=`/usr/bin/mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

# fem el dump de cada una per separat
for db in $databases; do
    /usr/bin/mysqldump --force --opt --user=$USER --password=$PASSWORD $db > $DIRECTORI_DB$db.sql
    echo -n $db
        echo " dumpejada correctament."
done

echo ""
echo "---------------------------"
echo "Dumpejant YML de Pepi i JY:"
echo "---------------------------"
echo ""

/usr/local/bin/php /home/juegosyonkis/public_html/symfony propel:data-dump > $DIRECTORI_DB/juegosyonkis.yml
/usr/local/bin/php /home/pepijuegos/public_html/symfony propel:data-dump > $DIRECTORI_DB/pepijuegos.yml

echo "juegosyonkis en yml dumpejada perfectament."
echo "pepijuegos en yml dumpejada perfectament."


# rsync excepte logs de sistema i logs de pepi i jy

echo -n "" > /backup/rsync_excluded.txt
echo "log" >> /backup/rsync_excluded.txt
echo "logs" >> /backup/rsync_excluded.txt
echo "cache" >> /backup/rsync_excluded.txt

# rsync local de home a backup/home_backup

echo ""
echo "--------------------"
echo "Fent rsync en local:"
echo "--------------------"
echo ""

rsync -av --delete --exclude-from=/backup/rsync_excluded.txt $DIR_TO_BACKUP $DIRECTORI_HOME

# rsync remot al server de backups tant del backup com de les db

echo ""
echo "------------------------------------------"
echo "Fent rsync de les bases de dades en remot:"
echo "------------------------------------------"
echo ""

rsync -abv --delete --backup-dir=/home/$BACKUP_LOGIN$DIRECTORI_DB_CHANGES$AVUI_HORA -e 'ssh -p23332' $DIRECTORI_DB $BACKUP_LOGIN@$BACKUP_SERVER:/home/$BACKUP_LOGIN$DIRECTORI_DB

echo ""
echo "----------------------------------------"
echo "Fent rsync del backup del home en remot:"
echo "----------------------------------------"
echo ""

rsync -abv --delete --backup-dir=/home/$BACKUP_LOGIN$DIRECTORI_HOME_CHANGES$AVUI_HORA -e 'ssh -p23332' $DIRECTORI_HOME $BACKUP_LOGIN@$BACKUP_SERVER:/home/$BACKUP_LOGIN$DIRECTORI_HOME