Skip to content

Instantly share code, notes, and snippets.

@JeromeParadis

JeromeParadis/drop_tables.sh

Created September 26, 2011 16:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JeromeParadis/1242594 to your computer and use it in GitHub Desktop.
Save JeromeParadis/1242594 to your computer and use it in GitHub Desktop.
Download ZIP
Efficiently drop all tables from MySQL
Raw
drop_tables.sh
mysqldump -u user_name -p password --no-data --add-drop-table database_name | grep ^DROP | mysql -u user_name -p password database_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment