lando drush @recap.prod sql-dump --structure-tables-list='watchdog,sessions,cas_data_login,history,captchasessions,cache,cache*' --result-file=/tmp/dump.sql\n
scp deploy@recap-www-prod1:/tmp/dump.sql .
scp dump.sql deploy@recap-www-staging1:.
ssh deploy@recap-www-staging1
cd /var/www/recap_cap/current
drush sql-dump > /home/deploy/staging.backup.sql # just in case you need to restore
drush sqlc < /home/deploy/dump.sql
drush status # confirm site bootstraps
drush cache:rebuild # clear cache
Preliminary instructions
lando drush @recap.prod sql-dump --structure-tables-list='watchdog,sessions,cas_data_login,history,captchasessions,cache,cache*' --result-file=/tmp/dump.sql\n scp deploy@recap-www-prod1:/tmp/dump.sql . scp dump.sql deploy@recap-www-staging1:. ssh deploy@recap-www-staging1 cd /var/www/recap_cap/current drush sql-dump > /home/deploy/staging.backup.sql # just in case you need to restore drush sqlc < /home/deploy/dump.sql drush status # confirm site bootstraps drush cache:rebuild # clear cache