Shell Script MySQL single tables backup

mysql_table_backup.sh

#!/bin/bash
 
if [ "$1" == "" ]; then
    echo "Usage: $0 <database> [output-path]"
    exit 1
fi
 
TABLES=`mysql -uroot -ppassword -B -N -e "select TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA='$1' AND TABLE_NAME <> 'project_users_views_archive_non';"`
 
OUT="$2"
if [ "$OUT" == "" ]; then
    OUT="."
fi
if [ ! -d $OUT ]; then
    echo "$OUT does not exist"
    exit 1
fi
 
for table in $TABLES; do
    echo -n "dumping $1.$table..."
    mysqldump -uroot -ppassword --add-drop-table $1 $table | gzip > $OUT/$1.$table.sql.gz
    echo "done"
done