Skip to content

Instantly share code, notes, and snippets.

@vincenzo
Last active August 29, 2015 14:26
Show Gist options
  • Save vincenzo/92e40246784ef73fa13b to your computer and use it in GitHub Desktop.
Save vincenzo/92e40246784ef73fa13b to your computer and use it in GitHub Desktop.
MySQL: drop all tables without dropping the DB
mysqldump -hhost -uusername -ppassword --no-data --add-drop-table databasename | grep ^DROP | mysql -uusername -ppassword -hhost databasename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment