Skip to content

Instantly share code, notes, and snippets.

@nylen
Created December 3, 2010 00:10
Show Gist options
  • Save nylen/726354 to your computer and use it in GitHub Desktop.
Save nylen/726354 to your computer and use it in GitHub Desktop.
MySQL backup and restore
# To do a backup:
mysqldump -uroot -pYourMySQLPassword --add-drop-database -B pfc_development > pfc_development-backup.sql
# To restore the same backup:
mysql -uroot -pYourMySQLPassword < pfc_development-backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment