Drush aliases

dkan.aliases.drushrc.php

<?php
$aliases['stable'] = array(
   'uri' => 'stable.dkan',
   'root' => '/var/www/stable.dkan/docroot',
   'db-url' => 'mysql://root:Sciawaker-n0wCit@localhost:3306/prod_dkan',
   'remote-host' => '192.168.57.100',
   'remote-user' => 'dkan',
   'path-aliases' => array(
     '%dump-dir' => '/home/dkan/db',
     '%files' => 'sites/default/files'
    ),
   'databases' =>
     array (
       'default' =>
       array (
         'default' =>
         array (
           'driver' => 'mysql',
           'username' => 'root',
           'password' => 'Sciawaker-n0wCit',
           'port' => '3306',
           'host' => 'localhost',
           'database' => 'prod_dkan',
         ),
      ),
    ),
    'variables' => array(
       'site_name' => 'dkan',
     ),
    'command-specific' => array (
      'sql-sync' => array (
        'no-cache' => TRUE,
      ),
    ),
    # This shell alias will run `mycommand` when executed via `drush @stage site-specific-alias`
    'shell-aliases' => array (
      'site-specific-alias' => '!mycommand',
    ),
 );