We have two websites running off a single domain:
Both websites have their own databases and are hosted by Acquia.
We've been using Drush 8.x and the sql-sync command for the past number of years to synchronizing the database between the local environment and Acquia.
Last week we upgraded to using Drush 10.3.6 and now we're running into an issue with the sql-sync command where it used to be able to target the db in the multi-site environment it now will only sync the main db.
# Application 'mywebsitetools', environment 'dev'. dev: root: /var/www/html/mywebsitedev/docroot ac-site: mywebsitetools ac-env: dev ac-realm: prod uri: mywebsitedev.prod.acquia-sites.com/mywebsitetools dev.livedev: parent: '@mywebsitedev.dev' root: /mnt/gfs/mywebsitedev.dev/livedev/docroot/sites/mywebsitetools host: mywebsitedev.ssh.prod.acquia-sites.com user: mywebsitedev.dev paths: drush-script: drush9
I then run the following sql-sync command to sync the databases
drush sql-sync @mywebsitetools.dev -l mywebsitetools @local.mywebsitetools -l mywebsitetools
I then get the following response back:
You will destroy data in mywebsite and replace with data from mywebsitedev.ssh.prod.acquia-sites.com/mywebsite.
Which tells me that Drush is going to sync the database for the https://www.mywebsite.com website instead of the https://www.mywebsite.com/mywebsitetools. Sure enough if I execute the command it takes about 15 minutes to sync the db and when i check /usr/local/var/mysql i can see that the date modified value of the mywebsite folder has changed as well as all the tables within the folder.
Using Drush 8.x and the old php aliases I would get a message like:
You will destroy data in mywebsitetools and replace with data from mywebsitedev.ssh.prod.acquia-sites.com/mywebsitetools.
And because this database is about 2MB it would take less than 2 minutes to sync.
I've spoken with the folks at Acquia Support and they suggested posting here because they haven't run into this issue either.
Any help figuring this out would be greatly appreciated.