Skip to content

Instantly share code, notes, and snippets.

@pavelburov
Last active August 29, 2015 14:04
Show Gist options
  • Save pavelburov/49de88ca5e17325d6914 to your computer and use it in GitHub Desktop.
Save pavelburov/49de88ca5e17325d6914 to your computer and use it in GitHub Desktop.
backup and restore mysql database
backup:
mysqldump --host=localhost --port=3306 --user=root --password=root databseName > dump.sql
restore:
mysql --host=localhost --port=3306 --user=root --password=root databseName < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment