Skip to content

Instantly share code, notes, and snippets.

@mikesmullin

mikesmullin/stream-mysqldump-import-over-ssh.sh

Last active July 15, 2018 16:48
Show Gist options
  • Save mikesmullin/2479918 to your computer and use it in GitHub Desktop.
Save mikesmullin/2479918 to your computer and use it in GitHub Desktop.
Download ZIP
Import remote MySQL database by streaming a compressed dump over SSH
Raw
stream-mysqldump-import-over-ssh.sh
ssh REMOTE-SERVER.COM "mysqldump -uroot -p REMOTE_DB | gzip -c" | gunzip | mysql -uroot LOCAL_DB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment