MySQL – Drop all tables without dropping the database

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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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