A bash script to download your remote MySQL schema and load it locally
Submitted by Richard on Tue, 11/10/2009 - 16:46
#!/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;
Tags:
Recent Blog Posts
Post new comment