I'm using drush 9 on a remote server and I'm trying to perform a sql:sync.
This is my alias:
live:
host: www.mysite.com
paths:
drush-script: '/home/wodby/drush-wrapper.sh'
files: files
root: /var/www/html/web
ssh:
options: '-p 9191 -o "AddressFamily inet" -o "StrictHostKeyChecking=no"'
uri: www.mysite.com
user: wodby
The "drush-wrapper" is a script (on remote server I've docker, so I use ssh to connect into the container. The wrapper is this:
export PATH=$PATH:/usr/local/bin
/home/wodby/.composer/vendor/drush/drush/drush.php $@
This alias works (for commands like drush cr or cim) but doesn't work the sql:sync command.
If I try to run drush sql:sync @d8.live @self I obtain:
Error: no database record could be found for source @d8.live
How should I add this configuration about database?