#!/bin/bash
#Purpose = Backup of Recording Module DB
#Created on 3-14-2017
#Author = Brandon Shutter
#Version 1.0
#START
TIME=`date +%b-%d-%y`
FILENAME=backup-$TIME.tar.gz

DESDIR=/home/shutter/BackupDirectory/endpointsmoduledb/
S3BUCKET='s3://elementvoip/netsapiensbackup/'$HOSTNAME'/endpointsmoduledb/'

# Database credentials
 user="root"
 password="sipbx"
 host="localhost"
 db_name="LiCfDomain"
# Set default file permissions
 umask 177
# Dump database into SQL file
mysqldump --user=$user --password=$password --host=$host $db_name --skip-add-drop-table --no-create-info > $DESDIR/$db_name-$TIME.sql
DBFILE=$DESDIR/$db_name-$TIME.sql
tar -cpzf $DESDIR/$FILENAME $DBFILE
cd $DESDIR && aws s3 cp $FILENAME $S3BUCKET
#END