Skip to content

Instantly share code, notes, and snippets.

@ethangardner

ethangardner/Restore MySQL Database

Created August 16, 2011 13:32
Show Gist options
  • Save ethangardner/1149073 to your computer and use it in GitHub Desktop.
Save ethangardner/1149073 to your computer and use it in GitHub Desktop.
Download ZIP
Restore MySQL Database
Raw
Restore MySQL Database
# Removes the database
mysqladmin -u USERNAME -p drop DATABASE
# Recreates the database
mysqladmin -u USERNAME -p create DATABASE
# Restores the database
mysql -u USERNAME -p DATABASE < FILENAME.mysql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment