Example aliases.drushrc.php file

gistfile1.php

<?php
// site.com aliases

$aliases['dev'] = array(
  'uri' => 'dev.site.com',
  'root' => '/var/www/dev',
);
$aliases['test'] = array(
  'uri' => 'test.site.com',
  'root' => '/var/www/test',
  'remote-host' => 'test.site.com',
  'remote-user' => 'username',
  'db-url' => 'mysqli://username:password@localhost/sitedb',
  'path-aliases' => array(
      '%files' => 'sites/default/files',
      '%dump' => '/tmp/drushtmp/backup.sql', // Arbitrary location for temp files
     ),
);
$aliases['prod'] = array(
  'uri' => 'prod.site.com',
  'root' => '/var/www/prod',
  'remote-host' => 'prod.site.com',
  'remote-user' => 'username',
  'db-url' => 'mysqli://username:password@localhost/sitedb',
  'path-aliases' => array(
      '%files' => 'sites/default/files',
      '%dump' => '/tmp/drushtmp/backup.sql', // Arbitrary location for temp files
     ),
);