#!/bin/bash

# Change your settings here
export WPCF='html/wp-config.php'
export FN='db/prod.sql'

if [ -f $WPCF ]; then
  WPDBNAME=`cat $WPCF | grep DB_NAME | cut -d \' -f 4`
  WPDBUSER=`cat $WPCF | grep DB_USER | cut -d \' -f 4`
  WPDBPASS=`cat $WPCF | grep DB_PASSWORD | cut -d \' -f 4`
  WPDBHOST=`cat $WPCF | grep DB_HOST | cut -d \' -f 4`
fi

echo "Backing up database.. to $FN  >>>
DB     -> $WPDBNAME
USER   -> $WPDBUSER
PASS   -> $WPDBPASS
HOST   -> $WPDBHOST
FN     -> $1
"


# Allow arguments
if [ "$1" != "" ]
then
$FN = $1
echo $FN
fi

mysqldump -u$WPDBUSER -p$WPDBPASS -h$WPDBHOST $WPDBNAME  > $FN

echo "Verifying $FN database with head/tail"
echo 'HEAD ---------------------------'
head $FN
echo 'TAIL ---------------------------'
tail $FN
echo '---------------------------'
echo 'Backup complete!'
echo '---------------------------'

unset WPDBNAME
unset WPDBUSER
unset WPDBPASS
unset WPDBHOST
unset FN
unset DB

exit 0