Skip to content

Instantly share code, notes, and snippets.

@bhaskarkc

bhaskarkc/import_export_gz.sql

Forked from rakeshtembhurne/import_export_gz.sql
Created March 5, 2019 04:05
Show Gist options
  • Save bhaskarkc/aec2621b19d631d6409dec521706ad06 to your computer and use it in GitHub Desktop.
Save bhaskarkc/aec2621b19d631d6409dec521706ad06 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