Even though I have setup site aliases with %dump-dir and %dump set, when trying to do sql-sync, I get the message about the temp files and to setup the dump-dir or dump variables.

Here is the aliases.drushrc.php:

<?php
$aliases['local'] = array(
'root' => 'C://wamp/www/local',
'uri' => 'localhost',
'db-url' => 'mysql://root@localhost/local',
'path-aliases' => array(
'%dump-dir' => 'C:/drush/drush-dumps',
'%dump' => 'C:/drush/dump.sql',
),
);
$aliases['live'] = array(
'root' => '/home/site/www/site',
'uri' => 'www.site.com',
'remote-host' => 'www.site.com',
'remote-user' => 'root',
'path-aliases' => array(
'%dump-dir' => '/home/site/tmp',
'%dump' => '/home/site/tmp/dump.sql',
),
);

Comments

eelkeblok’s picture

eelkeblok
he/him
Primary language Dutch
Location Netherlands 🇳🇱
commented

I seem to have the same problem, but on Mac OS X (Lion)

drewish’s picture

drewish commented

subscribe, same issue on lion. wondering if i'm just expecting it to work differently.

that0n3guy’s picture

that0n3guy commented

I think I have the same issue. I am doing drush sql-sync gtbc.local @server

Doing drush site-alias gtbc.local I get:

$aliases['gtbc.local'] = array (
  'root' => 'c:/xampp/htdocs/drupal-7.9',
  'uri' => 'gtbc.local',
);

Doing drush site-alias @server i get:

$aliases['server'] = array (
  'uri' => 'dev.gtbc.mydevserver.com',
  'root' => '/var/aegir/platforms/drupal-7.9',
  'remote-host' => 'gtbc.mydevserver.com',
  'remote-user' => 'aegir',
);

Here is the output I get when using sql sync:

$ drush sql-sync @self @server
WARNING:  Using temporary files to store and transfer sql-dump.  It is recommend
ed that you specify --source-dump and --target-dump options on the command line,
 or set '%dump' or '%dump-dir' in the path-aliases section of your site alias re
cords. This facilitates fast file transfer via rsync.

You will destroy data from gtbc.mydevserver.com/devgtbcmydevserver and replace with da
ta from gtbc.

You might want to make a backup first, using the sql-dump command.

Do you really want to continue? (y/n): y
The source and destination cannot both be remote.
rsync error: syntax or usage error (code 1) at main.c(1148) [Receiver=3.0.8]
Could not rsync from C:\Users\quadwin\AppData\Local\Temp\gtbF132.tmp     [error]

to
aegir@gtbc.mydevserver.com:C:\Users\quadwin\AppData\Local\Temp\devF133.tmp

My server is LAMP not windows so the to aegir@gtbc.mydevserver.com:C:\Users\quadwin\AppData\Local\Temp\devF133.tmp is messed up for sure.

that0n3guy’s picture

that0n3guy commented

I think my issue is related to #1363610: sql-sync command fix on Drush on Windows

moshe weitzman’s picture

moshe weitzman commented
Status: Active » Postponed (maintainer needs more info)

sqlsync tests are passing on windows. is resolved?

Bevan’s picture

Bevan commented
Version: » 8.x-6.x-dev

#1730758: sql-sync ignores dump-dir option in drushrc.php is similar but not the same.

greg.1.anderson’s picture

greg.1.anderson commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)
Issue tags: +Needs migration

This issue was marked closed (won't fix) because Drush has moved to Github.

If desired, you may copy this bug to our Github project and then post a link here to the new issue. Please also change the status of this issue to closed (duplicate).

Please ask support questions on Drupal Answers.