Skip to content

Instantly share code, notes, and snippets.

@mrsweaters

mrsweaters/backup_and_restore.sql

Created March 3, 2014 18:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mrsweaters/9331658 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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