MySQL Dump Tables

#!/bin/bash
USER="user"
PASSWORD="password"
HOST="localhost"
MYSQL_OPTS="--compact --single-transaction --skip-opt --quick --no-create-info --skip-triggers"

if [ "$1" == "" ]; then
    echo "Usage: $0 database-name [output-dir]"
    exit 1
fi

TABLES=`mysql -u $USER -p$PASSWORD -h $HOST -B -N -e "select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA='$1'"`
OUT="$2"
if [ "$OUT" == "" ]; then
    OUT="./sql"
fi
if [ ! -d $OUT ]; then
    echo "$OUT does not exist"
    exit 1
fi

if [ ! -d $OUT/$1 ]; then
    mkdir $OUT/$1
fi
 
for table in $TABLES; do
    echo -n "dumping $1.$table..."
    mysqldump --user=$USER --password=$PASSWORD --host=$USER $MYSQL_OPTS $1 $table > $OUT/$1/table.sql
    echo "done"
done