Adam Williams

So I don't have to remember this later

Twitter

Google+

Github

Drop all tables in MySQL DB

This will drop all tables in given database. See the ServerFault page if any tables have foreign key constraints.

mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]

Source: ServerFault