#!/bin/sh

#############################################################
# File:         dbbackup.sh
# Description:  A shell script to backup Multiple MySQL database
# Features:     The script can create a MySQL dump, compress it
#               then both store a copy in the server and send a
#               copy to the defined email address
# Supported OS: FreeBSD and RedHat, should work with other distributions
#
# Version: 1.0
# License: GPL
#
#How to install:
#
# 1. Upload dbbackup.sh to your account. i.e. in your home directory
# 2. Set the permission for the script to 755
#
#Cron:
#
#  Example: This will cause the cron to run every day at 2AM.  Be sure
#  to change "/path/to" to the location where you placed dbbackup.sh.  
#
#  0 2 * * * sh /path/to/dbbackup.sh 
#
#
#  BY KIONIC INC (www.kionic.com)
#  Questions, comments, suggestions, or improvements please send to
#  stephen@kionic.com
#############################################################


####DEFINE THESE#############################################

#Enter the cpanel username here
USER="control panel username";

#Enter the cpanel password here
PASSWORD="control panel password";

#Enter the database names here
DATABASES="dbname1 dbname2";

#Zipping options. 1 means you will get mail with a bz2 copy else you will get a gz copy bz2 is more powerful.
BZIP="0";

#Enter the full path to where you would like to store the backup here
#i.e. make a folder in your home directory, example: dbbackup
#then the path is /home/username/dbbackup
PATH="/path/to";

#Enter the email address you would like to receive the backup
EMAIL="youremail@here.com";

####END CHANGE HERE###########################################

#The main function which will create the required backup and send the mail
backup ()
{
	DATE=`/bin/date "+%d-%m-%Y"`;
	DUMP="$DATABASE-$DATE";
	EXT1=".sql";
	EXT2=".tar";
	EXT3=".gz";
	EXT4=".bz2";

	#Locate the mysqldump and mail commands
	if [ -f /etc/redhat-release ]
	then
	       	MAIL="/bin/mail";
	else
	        MAIL="/usr/bin/mail";
	fi
	
	if [ -e "/usr/bin/mysql" ]; then
        	MYSQLDUMP="/usr/bin/mysqldump";
	else
        	MYSQLDUMP="/usr/local/bin/mysqldump";
	fi

	#Create the MySQL dump
	echo "$PATH/$DUMP$EXT1";
	$MYSQLDUMP --add-drop-table --user $USER --password=$PASSWORD $DATABASE >> "$PATH/$DUMP$EXT1";

	#Compress the dump
	cd $PATH;
	/bin/tar -cf $DATABASE-$DATE$EXT2 $DATABASE-$DATE$EXT1;
	
	echo $BZIP;

	#Zip and Send mail - as an attachment
	if [ $BZIP -eq "0" ]
	then
		/bin/gzip $DATABASE-$DATE$EXT2;
		/usr/bin/uuencode $DUMP$EXT2$EXT3 $DUMP$EXT2$EXT3 |$MAIL -s "Mysql Backup For $DATABASE" $EMAIL ;
	elif [ $BZIP -eq "1" ]
	then
		/usr/bin/bzip2 $DATABASE-$DATE$EXT2;
		/usr/bin/uuencode $DUMP$EXT2$EXT4 $DUMP$EXT2$EXT4 |$MAIL -s "Mysql Backup For $DATABASE" $EMAIL ;
	fi

	#Remove the mysql dump (but still keep the compressed copy)
	/bin/rm -f $DUMP$EXT1;

	#Task complete
	cd;
}

# Function which backs up database one by one.
for DATABASE in $DATABASES
do
	echo $DATABASE;
	backup;
done

exit;