Dump a Laravel Forge site's DB through SSH using the .env's credentials

forge-db.sh

#!/usr/bin/env bash

SERVER="$1"
SITE="$2"

# script to run in the remote host
REMOTE_CMD="
# ensure the site exists in the user's home
if [ ! -d $SITE ]; then
    echo '$SITE' not found, aborting
    exit
fi

# ensure .env exists in the site's root
if [ ! -f \"$SITE/.env\" ]; then
    echo '.env' not found, aborting
    exit
fi

cd $SITE

# load DB related .env vars
export \$(grep '^DB_' .env)

# dump default project's DB
mysqldump -h\$DB_HOST -u\$DB_USERNAME -p\$DB_PASSWORD \$DB_DATABASE
"

ssh "$SERVER" "$REMOTE_CMD"