Skip to content

Instantly share code, notes, and snippets.

@lucasff

lucasff/dumpoverssh.sh

Forked from kirkegaard/dumpoverssh.sh
Created October 10, 2015 18:32
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 lucasff/7532cf675b7f3a8e6f37 to your computer and use it in GitHub Desktop.
Save lucasff/7532cf675b7f3a8e6f37 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
mysqldump -u MYSQL_USERNAME -p YOUR_DATABASE | gzip -c | ssh USERNAME@YOUR_TO_HOST 'cat > ~/dump.sql.gz'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment