migrate.sh

#!/bin/bash

# Migrates the database from your Trellis/bedrock/sage remote server to your local box, and syncs the WP uploads folder as a bonus. It will ruthlessly overwrite your local database, so be careful.

WEB_USER="web" # or root, using web makes files have the correct permissions for WP
WEB_URL="" 
LOCAL_URL="192.168.50.5" 
VAGRANT_ID="" # $ vagrant global-status
WP_DIR="" #/srv/www/(sitename)
LOCAL_DIR="" # /users/... (sitename)/site/web/app/uploads/

# Export DB from production machine and change the site name to the dev one
ssh -t $WEB_USER@$WEB_URL "cd $WP_DIR/current/web && wp db export $WP_DIR/shared/uploads/db/production.sql && sed 's/\/\/$WEB_URL/\/\/$LOCAL_URL/g' $WP_DIR/shared/uploads/db/production.sql > $WP_DIR/shared/uploads/db/dev.sql;"

# Sync uploads folder between production and local
rsync -rav $WEB_USER@$WEB_URL:$WP_DIR/shared/uploads/ $LOCAL_DIR

# Import production db to dev box
vagrant ssh $VAGRANT_ID -- -t "cd $WP_DIR/current/web && wp db import app/uploads/db/dev.sql;"