dumps

#!/bin/sh

while [ 1 ] ; do
   if [ "${1#--user=}" != "$1" ] ; then
      USER="${1#--user=}"
   elif [ "$1" = "-u" ] ; then
      shift ; USER="$1"
   elif [ "${1#--password=}" != "$1" ] ; then
      PASS="${1#--password=}"
   elif [ "$1" = "-p" ] ; then
      shift ; PASS="$1"
   elif [ -z "$1" ] ; then
      break # The keys ended
   else
      echo "Warning: Unknown key" 1>&2
      exit 1
   fi
   shift
done

CWD=$(dirname "$0") # current dir
TMP=${CWD}/tmps
DUMPS=${CWD}/dumps

# DBs
DB[0]="demo"
DB[1]="test"

mkdir ${TMP} ${DUMPS}

if [[ ${USER} != "" ]]; then
  for n in "${DB[@]}"; do
      mysqldump -u${USER} -p${PASS} ${n} > ${TMP}/${n}.sql
  done

  cd ${TMP}
  tar -cvjf `date +${DUMPS}/dumps_%Y%m%d.%H%M%S.tar.gz` *
  cd -
fi;