Skip to content

Instantly share code, notes, and snippets.

@weblogix

weblogix/mysql_cheetsheet.md

Created September 5, 2017 15:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save weblogix/34b354e1884b888e00786a1bb7d3aca8 to your computer and use it in GitHub Desktop.
Save weblogix/34b354e1884b888e00786a1bb7d3aca8 to your computer and use it in GitHub Desktop.
Download ZIP
[MySQL Cheetsheet] #mysql #mariadb
Raw
mysql_cheetsheet.md

Exporting a Compressed MySQL Dump

mysqldump -u {user} -p {database} | gzip > {database}.sql.gz

Importing a Compressed MySQL Dump

gzip -dc < {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