Database dump script

getdb.sh

#!/usr/bin/env bash

# Remote database credentials
RDBNAME=""
RDBUSER=""
RDBPASS=""

# Local database credentials
LDBNAME=""
LDBUSER=""
LDBPASS=""

# SSH credentials
SSHUSER=""
SSHADRESS=""

# Script:
# 1. Dump DB
# 2. Copy dump to local
# 3. Remove dump from remote
# 4. Import dump into local
echo "mysqldump -u$RDBUSER -p$RDBPASS $RDBNAME > ~/$RDBNAME.sql" | ssh $SSHUSER@$SSHADRESS
scp $SSHUSER@$SSHADRESS:~/$RDBNAME.sql ./
echo "rm ~/$RDBNAME.sql" | ssh $SSHUSER@$SSHADRESS
cat $RDBNAME.sql | mysql -hlocalhost -u$LDBUSER -p$LDBPASS $LDBNAME