Here is a handy little snippet for deleting all the tables in a database. Replace 'uname' and 'dbname' as required.
mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "drop table " $1 ";"}' | mysql -u uname dbname
