Skip to content

Instantly share code, notes, and snippets.

@pixelbrackets

pixelbrackets/bash

Created January 7, 2013 18:47
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 pixelbrackets/4477397 to your computer and use it in GitHub Desktop.
Save pixelbrackets/4477397 to your computer and use it in GitHub Desktop.
Download ZIP
Use gzip for imports and exports in MySQL
Raw
bash
#export
mysqldump -u username -p dbname | gzip > dbdump.sql.gz
#import
zcat dbdump.sql.gz | mysql -u username -p dbname
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment