iamstoick/drush.md

Last active February 26, 2017 21:58

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/iamstoick/2a7050039b6e9a0d5af0a52141c2fef5.js"></script>
Save iamstoick/2a7050039b6e9a0d5af0a52141c2fef5 to your computer and use it in GitHub Desktop.

A Drush snippet on how to backup Drupal database and compress it after.

Raw

drush sql-dump --gzip --result-file=/path/to/target/[DATABASE_NAME]-$(date +%Y-%m-%d-%H.%M).sql

Remove all caches

drush sql-dump --gzip --skip-tables-list=cache,cache_* --result-file=/path/to/target/[DATABASE_NAME]-$(date +%Y-%m-%d-%H.%M).sql

Just changed the [DATABASE_NAME] with your database.