Skip to content

Instantly share code, notes, and snippets.

@apostergiou

apostergiou/mysql.md

Last active March 21, 2017 09:37
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 apostergiou/931747694019cbd9436121ed68b66e33 to your computer and use it in GitHub Desktop.
Save apostergiou/931747694019cbd9436121ed68b66e33 to your computer and use it in GitHub Desktop.
Download ZIP
How to Back Up and Restore a MySQL Database
Raw
mysql.md

Back up From the Command Line (using mysqldump)

$ mysqldump -u root -p -h 127.0.0.1 --database Users --add-drop-database > ~/users_backup.sql

Back up your MySQL Database with Compress

$ mysqldump -u root -p -h 127.0.0.1 --database Users --add-drop-database | gzip -9 > ~/users_backup.sql.gz

Restoring your MySQL Database

$ scp remote_user@server:~/users_backup.sql.gz .
$ gunzip < users_backup.sql.gz | mysql -u [uname] -p[pass] [dbname]

or

$ ssh remote_user@server  mysqldump -u root -p -h 127.0.0.1 --database Users --add-drop-database | gzip -9 > users_backup.sql.gz
$ gunzip < users_backup.sql.gz | mysql -u [uname] -p[pass] [dbname]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment