Skip to content

Instantly share code, notes, and snippets.

@baringji
Last active August 29, 2015 14:00
Show Gist options
  • Save baringji/11102152 to your computer and use it in GitHub Desktop.
Save baringji/11102152 to your computer and use it in GitHub Desktop.
Create a MySQL dump using GNU zip (gzip).

mysqldump -u[username] -p[password] --add-drop-database -B [database] --opt | gzip -9 > filename.sql.gz

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment