# This script must be executed by crontab in order to backup xtribe database
# Check if it is executed with crontab -l or add it with crontab -e
#!/bin/sh
database_name=xtribe
database_user=root
database_password=t0t0r0Xtribe

echo -n "[$(date)] " >> /var/log/backup_db_xtribe.log

touch /var/log/backup_db_xtribe.log

exec 2>> /var/log/backup_db_xtribe.log
exec > /dev/null

# pre commit split ther db in three for installation issues
cd /var/www/xtribe.eu/etsmaintenance/git/
sh pre-commit

mkdir -p /var/www/backup_db_xtribe
cp /var/www/xtribe.eu/etsinstall/db* /var/www/backup_db_xtribe/
cp /var/www/xtribe.eu/files/custom_data_db/db* /var/www/backup_db_xtribe/
# for backup, the entire database gets dumped too
cd /var/www/backup_db_xtribe
mysqldump -u $database_user -p$database_password $database_name > /var/www/backup_db_xtribe/db_full.sql

zip $(date +%F).zip /var/www/backup_db_xtribe/db* 
rm /var/www/backup_db_xtribe/db*

echo "Backup succesfully completed..." >> /var/log/backup_db_xtribe.log