Skip to content

Instantly share code, notes, and snippets.

@adrianosaaquino
Last active August 29, 2015 14:16
Show Gist options
  • Save adrianosaaquino/205dfda6d9d70bff9302 to your computer and use it in GitHub Desktop.
Save adrianosaaquino/205dfda6d9d70bff9302 to your computer and use it in GitHub Desktop.
MySql - Create/Restore DUMP from schema structure and data compressed
Create dump.
$ mysqldump -uroot -proot schema | gzip -c > file.sql.gz
Restore dump.
$ gunzip < file.sql.gz | mysqldump -uroot -proot schema
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment