Skip to content

Instantly share code, notes, and snippets.

@JeromeParadis
Created September 26, 2011 16:05
Show Gist options
  • Save JeromeParadis/1242594 to your computer and use it in GitHub Desktop.
Save JeromeParadis/1242594 to your computer and use it in GitHub Desktop.
Efficiently drop all tables from MySQL
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