#Delete MySQL tables with a given prefix
DB_NAME='your_db'
DB_USER='your_db_user'
DB_PASSWORD='your_password'
$PREFIX='your_prefix_'

mysql -u $DB_USER -p${DB_PASSWORD} --silent --skip-column-names -e "SHOW TABLES" $DB_NAME | grep $PREFIX | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -u $DB_USER -p${DB_PASSWORD} -v $DB_NAME