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

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s