Snatch is a console tool to download a remote MySQL database dump via SSH protocol.
Does not require to install anything on server.
gem install snatchdb
To create a new snatch profile just type
snatch --new PROFILE_NAME
That will generate a sample YAML formatted profile in current directory. Use your favorite editor to change the server settings.
--- host: YOUR_HOSTNAME user: YOUR_SSH_USER password: YOUR_SSH_PASSWORD db_user: MYSQL_USER db_password: MYSQL_PASSWORD db_list: - database1 - database2
host: Remote server hostname
user: Remote server ssh user
password: Remote server ssh password (can leave as is if using ssh public key auth)
port: Retote server ssh server port (default: 22)
db_user: Local MySQL server username
db_password: MySQL server password (leave blank if no password)
db_list: List of all databases to dump
To download a dump type:
Snatch is handling the following errors:
Invalid SSH credentials
Invalid MySQL credentials
Requested database is not found
If everything works fine you will get a file “host_timestamp.sql.gz” in your current directory. Just import into your mysql server and you're ready to go.
Copyright © 2011 Dan Sosedoff.