Does "DROP TABLE *" work? I haven't needed to drop all of my table from MySQL so I'm not sure if the DROP TABLE command will take a wild card.
If that doesn't work why don't you just write yourself a little PHP script to do it and call that. But remember to remove the script once you are done with it since you don't want someone triggering it once you get everything built back up.
<?php
$tables = mysql_list_tables($database);
for ($i = 0; $i < mysql_num_rows($tables); $i++) {
$query = "DROP TABLE " . mysql_tablename($tables, $i);
mysql_db_query($conn, $query);
}
?>
Just add the code to connect to your database and then call this script and it should delete every table in your database. You may want to double check that there aren't any tables that you want/need to keep and put in some code to skip those.
