How-to: Drop all tables from a mysql database

Submitted by boydjd on Thu, 03/27/2008 - 15:47

Posted in

Much easier than have to drop a database, recreate it, and then grant privileges again.

mysqldump -u <username> -p <password> --add-drop-table --no-data <database> | grep ^DROP | mysql -u <username> -p <password <database>

Trackback URL for this post:

http://www.jbip.net/trackback/41

Submitted by Irakli Nadareishvili (not verified) on Wed, 05/06/2009 - 10:55.

You do not have to grant privileges again if you drop/recreate database in MySQL (at least in 5, do not remember in 4, but pretty sure - the same).

Nice code snippet though.