drop empty tables

drop_tables.sh

#!/bin/sh

# path settings
MYSQL=`which mysql`

# mysql settings
DB="MYDB"
HOST="127.0.0.1"
USER="root"
PASS="root"

# backup file settings
OPTS=""

# get tables
for t in `$MYSQL --host=$HOST --user=$USER --password=$PASS $OPTS $DB -e'SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_ROWS =0 AND TABLE_SCHEMA = "$DB"' | grep -v TABLE_NAME`; 
    do $MYSQL --host=$HOST --user=$USER --password=$PASS $OPTS $DB -e "DROP TABLE $t;";
done