#!/bin/bash
domains=(somedomain.com)
sqldbs=(application_production)

usernames=(root)
passwords=(password)

dreamhost_user=(d_user)
dreamhost_server=(d.host.com)


opath=$HOME/backups/database/

mysqlhost=localhost

suffix=$(date +%m-%d-%Y-%H-%M)

for (( i = 0 ; i < ${#domains[@]} ; i++ ))
do
	cpath=$opath${domains[$i]}
	if [ -d $cpath ]
	then
		filler="just some action to prevent syntax error"
	else
		echo Creating $cpath
		mkdir -p $cpath
	fi
	SQLFILE=${cpath}/${sqldbs[$i]}_$suffix.sql.gz

	mysqldump -c -h $mysqlhost --user ${usernames[$i]} --password=${passwords[$i]} ${sqldbs[$i]} | gzip > $SQLFILE

  rsync -aP --protocol=29  ~/backups/database/ ${dreamhost_user}@${dreamhost_server}:~/backups/database

  rm ~/backups/database/somedomain.com/*


	rsync -aP --protocol=29 ~/public_html/somedomain.com/shared/attachments ${dreamhost_user}@${dreamhost_server}:~/backups/files/somedomain.com/attachments/${suffix}


	if [ $? -eq 0 ]
	then
		printf "%s was backed up successfully to %s" ${sqldbs[$i]} $SQLFILE
		printf "Files were successfully backed up"
	else
		printf "WARNING: An error occured while attempting to backup %s to %s" ${sqldbs[$i]} $SQLFILE
	fi



done