ssh_remote_commands_example.sh

#!/usr/bin/env bash
echo "Creating and downloading live database image..."
ssh username@server.com 'mysqldump -u username -ppassword dbname | bzip2 > image.sql.bz'
scp username@server.com:./image.sql.bz ~/Desktop/
ssh username@server.com 'rm -rf image.sql.bz'
echo "Done. Importing database..."
bunzip2 ~/Desktop/image.sql.bz
mysql -u username local_dbname < ~/Desktop/image.sql
rm -rf ~/Desktop/image.sql
echo "Done. Database update complete."