remote_mysql_retrieval.sh

#!/bin/bash
REMOTEUSER=username
REMOTEPASS=password
REMOTECOMPUTER=remotecomputer.com
REMOTEMYSQLUSER=mysqllogin
REMOTEMYSQLPASS=mysqlpass
DB=database
FILENAME=dbschema.sql
LOCALMYSQLUSER=localuser
LOCALMYSQLPASS=localpassword

ssh -l "$REMOTEUSER" "$REMOTECOMPUTER" "mysqldump -u$REMOTEMYSQLUSER -p$REMOTEMYSQLPASS $DB -d > $FILENAME;"

ftp -in $REMOTECOMPUTER<<ENDOFDOWNLOAD
quote USER $REMOTEUSER
quote PASS $REMOTEPASS
mget $FILENAME
bye
ENDOFDOWNLOAD

mysql -u$LOCALMYSQLUSER -p$LOCALMYSQLPASS<<MYSQLEND
DROP DATABASE IF EXISTS $DB;
CREATE DATABASE $DB;
MYSQLEND
mysql -u$LOCALMYSQLUSER -p$LOCALMYSQLPASS $DB < $FILENAME;