For Drush 8:
cat ~/.drush/my.aliases.drushrc.php
/** * @file yoursite.aliases.drushrc.php * Site aliases for [your site domain] * Place this file at ~/.drush/ (~/ means your home path) * * Usage: * To copy the development database to your local site: * $ drush sql-sync @yoursite.dev @yoursite.local * To copy your local database to the development site: * $ drush sql-sync @yoursite.local @yoursite.dev --structure-tables-key=common --no-ordered-dump --sanitize=0 --no-cache * To copy the production database to your local site: * $ drush sql-sync @yoursite.prod @yoursite.local * To copy all files in development site to your local site: * $ drush rsync @yoursite.dev:%files @yoursite.local:%files * Clear the cache in production: * $ drush @yoursite.prod clear-cache all * * You can copy the site alias configuration of an existing site into a file * with the following commands: * $ cd /path/to/settings.php/of/the/site/ * $ drush site-alias @self --full --with-optional >> ~/.drush/mysite.aliases.drushrc.php * Then edit that file to wrap the code in < ? php ? > tags. */ /** * Local alias * Set the root and site_path values to point to your local site */ 'root' => '/var/www/docroot', 'uri' => 'my.docksal', 'path-aliases' => array ( '%drush' => '/usr/local/bin', '%site' => 'sites/default/', ), ); 'uri' => 'my.altagrade.com', 'root' => '/home/altacom/domains/my.altagrade.com/public_html', 'remote-user' => 'altacom', 'remote-host' => '66.160.206.201', 'ssh-options' => '-p 19753', // To change the default port on remote server '%dump-dir' => '/tmp', ), 'no-cache' => TRUE, 'structure-tables-key' => 'common', ), ), // No need to modify the following settings 'sanitize' => TRUE, 'no-ordered-dump' => TRUE, // 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'), ), ), ), );
To convert Drush 8 style alias file to Drush 9:
mv /home/docker/.drush/my.aliases.drushrc.php /var/www/drush/sites cd /var/www/drush/sites drush site:alias-convert rm -rf my.site.yml rm -rf my.aliases.drushrc.php
Check the status of production site:
cd /var/www drush @prod status
0) cat /home/docker/.bash_aliases
function pull_db() { cd /var/www/docroot drush -y sql-sync @prod @dev drush -y dis varnish memcache_admin && drush -y dis masquerade memcache commerce_stripe emaillog nicemessages drush -y dis masquerade_views memcache_admin drush -y en search_krumo drush vset error_level 2 yes | drush -y en drush_extras drush -y en devel permissions_variable commerce_payment_example drush -y block-configure --module=devel --delta=switch_user --region=footer_firstcolumn --weight=0 drush -y dis memcache drush -y dis varnish memcache_admin && drush -y dis masquerade memcache commerce_stripe emaillog nicemessages drush -y rules-disable commerce_payment_commerce_stripe drush -y en mojave drush uli 1 } alias pull_private='drush -y rsync @prod:%private @dev:%private' alias pull_theme='drush -y rsync @prod:%theme @dev:%theme' alias pull_custom='drush -y rsync @prod:%custom @dev:%custom' alias pull_files='drush -y rsync @prod:%files @dev:%files' alias pull_all='drush rsync --exclude-conf @prod @dev' alias push_theme='drush -y rsync @dev:%theme @prod:%theme' alias push_custom='drush -y rsync @dev:%custom @prod:%custom' alias custom='cd /var/www/docroot/sites/all/modules/custom' alias theme='cd /var/www/docroot/sites/all/themes/altagrade'
- Log in to post comments