Skip to content

Instantly share code, notes, and snippets.

@hitautodestruct

hitautodestruct/mysql-dump.sh

Last active August 12, 2019 06:34
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 hitautodestruct/17981e100155dda9251699a606c582bf to your computer and use it in GitHub Desktop.
Save hitautodestruct/17981e100155dda9251699a606c582bf to your computer and use it in GitHub Desktop.
Download ZIP
An example of exporting an sql db from mysql from a cli
Raw
mysql-dump.sh
# export dump
mysqldump -u [username] -p[password] [dbname] | gzip > ~/[dbname].sql.gz
# import
mysql -u username -p database_name < file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment