You could use the following command to drop all the tables of a MySQL DB.

• mysqldump -u<user> -p<pwd> --add-drop-table --no-data <db> | grep ^DROP | mysql -u<user> -p<pwd> <db>

Just replace the <user>, <pwd> and <db> with your MySQL username, password and database name. That’s all.

Done =)

Reference: MySQL drop all tables command