i can see from this post that rsync is trying to set group on the file which may not make sense for windows. The question is, how can i pass rsync options while running the sql-sync command as

drush sql-sync @linux_alias @windows_alias

I can run the same command between two linux drupal aliases without any problems.


  • im not a drush expert. But I imagine you need Cygwin or something similar for Windows. Rsync is not a native Windows command, so spluh it wont work between different OS hosts such as those. – tenken Apr 14 '13 at 5:16
  • @tenken Drush on windows installs Cwrsync which is implementation of rsync on windows. I can see the file getting copied in the temp directory, but the problem is, after copying the file to local computer, the Cwrsync tries to update its permissions which fails. And with this the sql-sync also fails. – Ranjan Apr 14 '13 at 12:37
  • Also, if i run the same command with 'no-cache' => FALSE,, the command runs successfully by using the sql dumped by the earlier command which had failed. Although, this time a new dump is not fetched from the remote server. – Ranjan Apr 14 '13 at 12:39

Okay, i got it running. Followed instructions at this blog and i'm able to run it.


The best way to solve this, is simply to add the following to your alias definition file for your local site:

  'target-command-specific' => array (  //commands used when this alias is the target
'sql-sync' => array (
  'create-db' => TRUE,  //create new database(merged databases can be trouble!)
  'mode' => 'rultvz',  // override sql-sync default $mode = '-akz' from rsync.core.inc


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.