#!/bin/sh

# Directory where you want the backup files to be placed
backupdir="/var/www/html/db_backup"

# List all of the MySQL databases that you want to backup in here, 
# each seperated by a space
databases="drganbug_medine"

# MySQL dump command, use the full path name here
mysqldumpcmd="mysqldump"

# MySQL Username and password
userpassword=" --user=drganbug_medine --password=0AC]Q~*TN!8o"

# MySQL dump options
dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables"

# Get the current timestamp
TS=`date +%Y%m%d%H%M%S`

# Create our backup directory if not already there
mkdir -p ${backupdir}
if [ ! -d ${backupdir} ] 
then
   echo "Not a directory: ${backupdir}"
   exit 1
fi

# Dump all of our databases
echo "Dumping MySQL Databases"
for database in $databases
do
   $mysqldumpcmd $userpassword $dumpoptions $database | gzip > ${backupdir}/${TS}-${database}.sql.gz
done