Drop or truncate tables in a mysql database

drop-or-truncate-db-tables.sh

#!/bin/bash
MDB="$1"
KEYWORD="$2"

# Detect paths
MYSQL=$(which mysql)
AWK=$(which awk)
GREP=$(which grep)
E_BADARGS=65

if [ $# -ne 2 ]
then
    echo "Usage: $0 {MySQL-Database-Name} {DROP|TRUNCATE}"
    echo "Drops/Truncates all tables from a MySQL"
    exit $E_BADARGS
fi

# make sure we can connect to server
$MYSQL -e "use $MDB"  &>/dev/null
if [ $? -ne 0 ]
then
	echo "Error - Cannot connect to mysql server using given username, password or database does not exits!"
	exit 2
fi

TABLES=$($MYSQL $MDB -e 'show tables' | $AWK '{ print $1}' | $GREP -v '^Tables' )
# make sure tables exits
if [ "$TABLES" == "" ]
then
	echo "Error - No table found in $MDB database!"
	exit 3
fi


QUERY="SET FOREIGN_KEY_CHECKS = 0;";
for t in $TABLES
do
    QUERY="${QUERY}${KEYWORD} table $t;"
done
QUERY="${QUERY}SET FOREIGN_KEY_CHECKS = 1;"
$MYSQL $MDB -e "${QUERY}"