How to skip specific tables with drush sql-dump?
Dump all tables except the cache table and tables starting with cache_.

drush sql-dump --skip-tables-list=cache,cache_* &gt; dumpfile.sql


Database structure only. No data at all.

drush sql-dump --extra=--no-data &gt; dumpfile.sql


Data only. No cache data and no cache structure.

drush sql-dump --skip-tables-list=cache,cache_* --data-only &gt; dumpfile.sql


No cache data but dump in their structures.

drush sql-dump --structure-tables-list=cache,cache_* &gt; dumpfile.sql


sql-dump documentation