example.aliases.drushrc.php

<?php
/**
 * This file goes in ~/.drush/
 * Rename to GROUPNAME.aliases.drushrc.php
 *
 * Examples (run from any path on your local environment):
 *
 * drush @example.dev status
 * drush sql-sync @example.stage @example.dev
 *
 */

$aliases['example.local'] = array (
  'root' => '/path/to/local/codebase',
  'uri' => 'example.local'
);

$aliases['example.stage'] = array(
  'uri' => 'stage.example.com',
  'root' => '/var/www/public_html',
  'db-url' => 'mysql://user:pass@localhost:3306/dbname',
  'remote-host' => 'stage.example.com',
  'remote-user' => 'user',
  'ssh-options' => '-p 12345',
  'path-aliases' => array(
    '%drush' => '/usr/bin',
    '%drush-script' => '/usr/bin/drush',
    '%dump' => '/var/www/sql_dump.stage.sql',
    '%files' => 'sites/stage.example.com/files',
    ),
);

$aliases['example.dev'] = array(
  'uri' => 'dev.example.com',
  'root' => '/var/www/public_html',
  'db-url' => 'mysql://user:pass@localhost:3306/dbname',
  'remote-host' => 'stage.example.com',
  'remote-user' => 'user',
  'ssh-options' => '-p 12345',
  'path-aliases' => array(
    '%drush' => '/usr/bin',
    '%drush-script' => '/usr/bin/drush',
    '%dump' => '/var/www/sql_dump.dev.sql',
    '%files' => 'sites/dev.example.com/files',
    ),
);

?>