Skip to content

Instantly share code, notes, and snippets.

@rakeshtembhurne

rakeshtembhurne/import_export_gz.sql

Created July 15, 2013 08:40
Show Gist options
  • Star 22 You must be signed in to star a gist
  • Fork 11 You must be signed in to fork a gist
  • Save rakeshtembhurne/5998421 to your computer and use it in GitHub Desktop.
Save rakeshtembhurne/5998421 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Import and export in gzip form
Raw
import_export_gz.sql
// Export database in gzip form
mysqldump -u user -p database | gzip > database.sql.gz
// Import database from gzip form
gunzip < database.sql.gz | mysql -u user -p database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment