#database connection information
  dbname=hermeshi_8     # (e.g.: dbname=drupaldb)
  dbhost=localhost
  dbuser=hermeshi_fangbo # (e.g.: dbuser=drupaluser)

# Website Files
  webrootdir=/home1/hermeshi/public_html/ebayapi/site  # (e.g.: webrootdir=/home/user/public_html)

# Default TAR Output File Base Name
  tarnamebase=sitebackup-
  datestamp=`date +'%Y-%m-%d'`

# Execution directory (script start point)
  startdir=`pwd`

# Temporary Directory
  tempdir=tmpbckdir$datestamp

#
# Input Parameter Check
#

if test "$1" = ""
  then
    tarname=$tarnamebase$datestamp.tgz
  else
    tarname=$1
fi

#
# Banner
#
echo ""
echo "backup.sh V1.0"


#
# Create temporary working directory
#
echo " .. Setup"
mkdir $tempdir
echo "    done"

#
# TAR website files
#echo " .. TARing website files in $webrootdir"
#cd $webrootdir
#tar cf $startdir/$tempdir/filecontent.tar . --exclude "xxx"
#echo "    done"

#
# sqldump database information
#
echo " .. sqldump'ing database:"
echo "    user: $dbuser; database: $dbname; host: $dbhost"
cd $startdir/$tempdir
mysqldump -p --user=$dbuser --host=$dbhost --add-drop-table $dbname > dbcontent.sql
echo "    done"


#
# Create final backup file
#
echo " .. Creating final compressed (tgz) TAR file: $tarname"
#tar czf $startdir/$tarname filecontent.tar dbcontent.sql
tar czf $startdir/$tarname dbcontent.sql

echo "    done"


#
# Cleanup
#
echo " .. Clean-up"
cd $startdir
rm -r $tempdir
echo "    done"


#
# Exit banner
#
echo " .. Full site backup complete"
echo ""