Skip to content

Instantly share code, notes, and snippets.

@anton-vlasenko
Last active May 29, 2019 11:21
Show Gist options
  • Save anton-vlasenko/96397b2044dc6ea43b3c91203da4c9e1 to your computer and use it in GitHub Desktop.
Save anton-vlasenko/96397b2044dc6ea43b3c91203da4c9e1 to your computer and use it in GitHub Desktop.
Compressing Mysqldump Output
mysqldump <mysqldump options> --skip-lock-tables --set-gtid-purged=OFF | gzip > outputfile.sql.gz
gunzip < outputfile.sql.gz | mysql <mysql options>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment