Skip to content

Instantly share code, notes, and snippets.

@afsardo

afsardo/mysqldump.sh

Last active July 9, 2017 14:14
Show Gist options
  • Save afsardo/6b973471af70b117cfe23ca64d637f9e to your computer and use it in GitHub Desktop.
Save afsardo/6b973471af70b117cfe23ca64d637f9e to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Backup w/ mysqldump
Raw
mysqldump.sh
# If for some reason you need to make a backup of your database here's how you dump and restore it.
# 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