Skip to content

Instantly share code, notes, and snippets.

@skounis

skounis/dump-nocache.sh

Last active November 14, 2023 14:09
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save skounis/407e32b4825bad6adccd364c08eb7f0b to your computer and use it in GitHub Desktop.
Save skounis/407e32b4825bad6adccd364c08eb7f0b to your computer and use it in GitHub Desktop.
Download ZIP
Dump Drupal DB without cache tables with drush
Raw
dump-nocache.sh
# Without cache
drush sql-dump --structure-tables-list=cache,cache_* > dumpfile.sql
# Without cache, search index and watchdog
drush sql-dump --structure-tables-list=cache,cache_*,search_index,watchdog > dumpfile.sql
# Without table spaces
drush sql-dump --structure-tables-list=cache,cache_*,search_index,watchdog --extra-dump="--no-tablespaces --column-statistics=0 --set-gtid-purged=OFF" > db.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment