remote db dump and local import via jumphost

backup-db.sh

#!/bin/sh 
DATE=`date +%Y%m%d` 
DBNAME="acmedb"
mysqldump --lock-tables=false  --extended-insert=FALSE -u db_user -psecret $DBNAME > /var/tmp/$DBNAME-full-$DATE.sql  
rm -fr /var/tmp/$DBNAME-full.sql*
cp /var/tmp/$DBNAME-full-$DATE.sql /var/tmp/$DBNAME-full.sql 
gzip /var/tmp/$DBNAME-full.sql

Makefile

DATE=$(shell date +%Y%m%d)
DBNAME="acmedb"

all: dump

dump:
	sudo service mysql restart
	ssh server1 ssh server2 /home/sysop/bin/backup-db.sh
	ssh server1 rm -f /var/tmp/$DBNAME-full.sql.gz
	ssh server1 scp server2:/var/tmp/$DBNAME-full.sql.gz /var/tmp/
	rm -f $DBNAME-full.sql.gz
	rm -f $DBNAME-full.sql
	scp server1:/var/tmp/$DBNAME-full.sql.gz $DBNAME-full-${DATE}.sql
	ssh server1 rm -f /var/tmp/$DBNAME-full.sql.gz 
	cp -fr $DBNAME-full-${DATE}.sql  $DBNAME-full.sql.gz 
	gzip -d $DBNAME-full.sql.gz 
	mysql $DBNAME < $DBNAME-full.sql