Skip to content

Instantly share code, notes, and snippets.

@semihkeskindev

semihkeskindev/import_export_gz.sql

Forked from rakeshtembhurne/import_export_gz.sql
Created April 16, 2020 10:22
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 semihkeskindev/2fa55ebc4e513ac5c27d444f9394bd62 to your computer and use it in GitHub Desktop.
Save semihkeskindev/2fa55ebc4e513ac5c27d444f9394bd62 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