Skip to content

Instantly share code, notes, and snippets.

@mrsweaters

mrsweaters/backup_and_restore.sql

Created March 3, 2014 18:41
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 mrsweaters/9331658 to your computer and use it in GitHub Desktop.
Save mrsweaters/9331658 to your computer and use it in GitHub Desktop.
Download ZIP
backup and restory mysql database
Raw
backup_and_restore.sql
backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment