Backup account and database shell script.

#!/bin/bash

#Show instructions
function show_usage {
  echo "Backup account and database, assuming /home/USER filesystem setup."
  echo "Usage:"
  echo "    -h Help menu - See this information"
  echo "  Files: "
  echo "    -a  Account user name, for use in /home/USER backup. If no path is set via -p flag, the /home/USER path will be backed up. "
  echo "    -f  Filepath to Backup "
  echo "  Database: "
  echo "    -d Name of Database to backup "
  echo "    -h Host of database, if not localhost "
  echo "    -p Database Password to use for backing up "
  echo "    -u Database User to use for backup "
  echo "  Backup File "
  echo "    -b Name and path of backup file to create. '.tar.bz2' will be appended to the filename "

  exit 1
}

#Sanity Check - are there no arguments?
if [ $# -eq 0 ]; then
  show_usage
fi

#Set variables to be used
user=''
filepath=''
database=''
dbfile=''
dbuser=''
dbpass=''
dbhost='127.0.0.1'
bkpath=''
finalbkpath=''
finalbkfile=''

#Parse flags
while getopts "ha:f:d:p:u:b:" OPTION; do
  case $OPTION in
    h)
      show_usage
      ;;
    a)
      user=$OPTARG
      ;;
    f)
      filepath=$OPTARG
      ;;
    d)
      database=$OPTARG
      dbfile="$database-`date +%Y%m%d`.sql"
      ;;
    h)
      dbhost=$OPTARG
      ;;
    p)
      dbpass=$OPTARG
      ;;
    u)
      dbuser=$OPTARG
      ;;
    b)
      bkpath=$OPTARG
      ;;
    *)
      show_usage
    ;;
  esac
done

#Backup based on filepath instead of /home/USER if used
if [ "$filepath" != '' ] && [ -d $filepath ]; then
  finalbkpath="$filepath"
elif [ -d /home/$user ]; then
  finalbkpath="/home/$user"
else
  echo 'Invalid file path or no user specified'
  show_usage
fi

#Get database dump, if database is defined
if [ "$dbuser" != "" ] && [ "$database" != "" ]; then
  mysqldump -u ${dbuser} -p${dbpass} -h ${dbhost} ${database} > ./${dbfile}
elif [ "$database" != "" ]; then
  mysqldump -h ${dbhost} ${database} > ./${dbfile}
fi

#Create backup
if [ -f ./${dbfile} ]; then
  tar -cjf backup-`date +%Y%m%d`.tar.bz2 ${finalbkpath} ./${dbfile}
else
  tar -cjf backup-`date +%Y%m%d`.tar.bz2 ${finalbkpath}
fi