Skip to content

Instantly share code, notes, and snippets.

@stojg

stojg/import-remote-db.sh

Created March 14, 2011 14:44
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 stojg/869224 to your computer and use it in GitHub Desktop.
Save stojg/869224 to your computer and use it in GitHub Desktop.
Download ZIP
Dump a mysql database remotely and importing it locally.
Raw
import-remote-db.sh
#!/bin/bash
SSH_SERVER=server.com
SSH_USER=user
REMOTE_DB_USER=remotedbuser
REMOTE_DB_PASSWORD=remotedbpassword
REMOTE_DB_SCHEMA=remotedbschema
LOCAL_DB_USER=localdbuser
LOCAL_DB_PASSWORD=localdbpassword
LOCAL_DB_SCHEMA=localdbschema
ssh $SSH_USER@$SSH_SERVER "mysqldump -u$REMOTE_DB_USER -p$REMOTE_DB_PASSWORD --default-character-set=utf8 --opt $REMOTE_DB_SCHEMA" | mysql -u$LOCAL_DB_USER -p$LOCAL_DB_PASSWORD $LOCAL_DB_SCHEMA
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment