Push Dump File Contents to Remote DB

This is a script demonstrating no-frills method to push a dumpfile to a remote mysql database.

#! /bin/bash
#
# @file pushdb.sh
#
# Usage: ./pushdb.sh path/to/dumpfile.sql
# 
DBHOST='DBHOST'
DBNAME='DBNAME'
DBUSER='DBUSER'
DBPASS='DBPASS'
if [[ $1 ]];then
  time  mysql -h "$DBHOST" -u "$DBUSER" -p"$DBPASS"  "$DBNAME" < $1
else
  echo "Requires path to sql file."
fi