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?