Skip to content

Instantly share code, notes, and snippets.

@morgant

morgant/dumpoverssh.sh

Forked from kirkegaard/dumpoverssh.sh
Last active July 11, 2018 04:29
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 morgant/0501da55c760b92304c640fdfc4db669 to your computer and use it in GitHub Desktop.
Save morgant/0501da55c760b92304c640fdfc4db669 to your computer and use it in GitHub Desktop.
Download ZIP
pipe a mysql dump through gzip and send it over ssh
Raw
dumpoverssh.sh
# dump to another server
mysqldump -u MYSQL_USERNAME -p YOUR_DATABASE | gzip -c | ssh USERNAME@YOUR_TO_HOST 'cat > ~/dump.sql.gz'
# dump from another server
ssh USERNAME@YOUR_TO_HOST 'mysqldump -u MYSQL_USERNAME -pPASSWORD YOUR_DATABASE | gzip -c' > ~/dump.sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment