Craft CMS - markhowellsmead/helpers GitHub Wiki

Download site to local via command line

#!/bin/bash
SSH_SERVER=""
REMOTE_PORT=""
WEBROOT=""
DOMAIN1_LIVE=""
DOMAIN1_DEV=""
DB_USER=""
DB_PASSWORD=""
DB_NAME=""
TODAY=$(date +%Y%m%d-%H:%M:%S)
DUMP_NAME="${DB_NAME}_${TODAY}.sql"

# Dump DB on remote server
ssh -p $REMOTE_PORT $SSH_SERVER "cd $WEBROOT && mysqldump -h 127.0.0.1 --protocol=TCP -u $DB_USER --password=$DB_PASSWORD $DB_NAME > $WEBROOT/$DUMP_NAME"

# Download dump
scp -P $REMOTE_PORT $SSH_SERVER:$WEBROOT/$DUMP_NAME .

# Remove dump from server
ssh -p $REMOTE_PORT $SSH_SERVER "rm $WEBROOT/$DUMP_NAME"

# Download site files (excluding .DS_Store)
rsync -azP -e "ssh -p $REMOTE_PORT" $SSH_SERVER:$WEBROOT . --exclude=".DS_Store"