Drop all tables in a MySQL database

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

| mysql -u[USERNAME] -p[PASSWORD] [DATABASE]

[USERNAME][PASSWORD] & [DATABASE] are all the details for your database.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.