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, 2013 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, 2013 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, 2013 at 12:39

1 Answer 1


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 and acknowledge you have read our privacy policy.

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