#!/bin/sh

#Backup Settings
pathSOSCI=/var/www/html/sosci
pathBACKUP=/var/www/backup
dbDatabase=sosci
dbUser=survey
dbPass=PASSWORD

# Timestamp for the File Name
datetime=`date +%Y-%m-%d_%H-%M-%S`

#File System Backup
tar --exclude=$pathSOSCI/system/session --exclude=$pathSOSCI/system/cache -czf $pathBACKUP/sosci-html-$datetime.tar.gz $pathSOSCI

#MySQL Database Backup
mysqldump -u$dbUser -p$dbPass -q --databases $dbDatabase | gzip -9 > $pathBACKUP/sosci-database-$datetime.sql.gz