One-liner for fetching the live-database on your dev server (or localhost)

Public

Being in your Drupal project directory use this command to fetch db from the site (live site) that site on a remote server and import it into your current local (dev) site (snippet source - http://orkjern.com/one-liner-fetching-live-database-your-dev-server-or-l...):

Get raw version
bash
  1. ssh myuser@remotemachine.com "drush --root=/path/in/remote/server sql-dump" | drush sql-cli

Comments

marcvangend's picture

Maybe I misunderstand, but why wouldn't you use drush sql-sync?