#!/bin/bash

DIR="$HOME/dump"
MUSER="[user]"
MPASS="[password]"
MHOST="[host]"
MDB="[database]"

PS3="Should delete \"$DIR\" directory? "
options=("[Y]" "[N]")
select opt in "${options[@]}"
do
	case $opt in
		"[Y]") echo "Deleting..."; rm -rf $DIR; break ;;
		"[N]") echo "Skipping..."; break ;;
	esac
done

[ -d $DIR ] || mkdir $DIR
echo "$(tput bold)Starting dump$(tput sgr0)"
for table in `echo "show tables" | mysql -u $MUSER -p$MPASS -h $MHOST $MDB | grep -v Tables_in_`; do
	FILE="$DIR/$table.sql.gz"
	echo "Dumping: $FILE";
	mysqldump --order-by-primary --compress --add-drop-table --allow-keywords -q -c -u $MUSER -p$MPASS -h $MHOST $MDB $table | gzip -9 > $FILE
done