domainname.aliases.drushrc.php

/**
 * Dsu local alias
 */
$aliases['dsu'] = array(
  'root' => '/home/username/public_html',
  'uri'  => 'domain.com',
  'path-aliases' => array(
    '%dump-dir' => '/tmp',
  ),
);

/**
 * Production alias
 */
$aliases['prod'] = array (
  'uri' => 'domainname.com',
  'root' => '/home/username/public_html',
  'remote-user' => 'root',
  'remote-host' => 'triton.itomic.com',
  'ssh-options'  => '-p 22',  // To change the default port on remote server
  'path-aliases' => array(
    '%dump-dir' => '/tmp',
  ),
  'source-command-specific' => array (
    'sql-sync' => array (
      'no-cache' => TRUE,
      'structure-tables-key' => 'common',
    ),
  ),
  // No need to modify the following settings
  'command-specific' => array (
    'sql-sync' => array (
      'sanitize' => TRUE,
      'no-ordered-dump' => TRUE,
      'structure-tables' => array(
       // You can add more tables which contain data to be ignored by the database dump
        'common' => array('cache', 'cache_filter', 'cache_menu', 'cache_page', 'history', 'sessions', 'watchdog'),
      ),
    ),
  ),
);