Kroko Just another WordPress weblog

September 5, 2011

Drop all tables in a MySQL database

Filed under: Linux — admin @ 3:06 pm

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.

Powered by WordPress