#!/bin/bash
domains=( domain.com, domain2.com )
sqldbs=( domain1_production, domain2_production )

usernames=( root, root, root )
passwords=(  pass, pass, pass )

opath=$HOME/backups/database/
 
mysqlhost=localhost
 
suffix=$(date +%m-%d-%Y)

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
 
	if [ $? -eq 0 ]
	then
		printf "%s was backed up successfully to %snn" ${sqldbs[$i]} $SQLFILE
	else
		printf "WARNING: An error occured while attempting to backup %s to %s" ${sqldbs[$i]} $SQLFILE
	fi
done