Skip to content

Instantly share code, notes, and snippets.

@milon
Last active December 10, 2017 08:31
Show Gist options
  • Save milon/1b105ffda4e6627f4ca5 to your computer and use it in GitHub Desktop.
Save milon/1b105ffda4e6627f4ca5 to your computer and use it in GitHub Desktop.
Mysql: Backup and Restore

#Mysql: Backup and Restore

Mysql Backup and restore through command line.

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