Tag Archives: mysqldump

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