Db-dump.sh

Used to dump the contents in database tables for backup purposes.

#!/bin/bash
dumpdir=/home/myaccount/dbdump
dt=`date +%d-%b-%Y`
dumpfile=$dumpdir/myaccount-dbdump-$dt.sql
/usr/bin/mysqldump --add-drop-table -uDBUSER -pDBPWD  DBNAME > $dumpfile
gzip $dumpfile

#mysql - #database - #programming - #junco - #grebe