script
#!/bin/bash

ssh -o StrictHostKeyChecking=no -i {{ssh_key}} -p {{port}} {{username}}@{{host}} << 'EOF'
cd {{path}}/projects/{{name}}
gunzip {{path}}/backup/{{name}}/{{db_file}}
drush sql-drop -y
drush sql-cli < {{path}}/backup/{{name}}/{{db_file_extract}}
drush cr
gzip {{path}}/backup/{{name}}/{{db_file_extract}}
EOF
ID
restore_db
Require Confirmation
On