keyboardcowboy/drush-truncate

Drush command for truncating one or many tables.

1.0.0 2017-08-04 17:04 UTC

Requires

• php: >=5.3.0
• composer/installers: ~1.0

GPL-2.0+

• Chris Albrecht

• database
• Drush

README

Simple drush utility to truncate database tables.

Truncate a single table:

$ drush truncate watchdog
Found 1 tables matching watchdog on yourdb.
watchdog
Truncate 1 table on yourdb? (y/n):

Truncate multiple tables:

# Use an asterisk as a wildcard.
$ drush truncate cache_entity_*
Found 5 tables matching cache_entity_* on yourdb.
cache_entity_comment
cache_entity_node
cache_entity_taxonomy_term
cache_entity_taxonomy_vocabulary
cache_entity_user
Truncate 5 tables on yourdb? (y/n):

Interactive mode lets you pick and choose.

$ drush truncate --interactive cache_entity_*
Found 5 tables matching cache_entity_* on yourdb.
Truncate yourdb.cache_entity_comment? (y/n): n
Skipped yourdb.cache_entity_comment.
Truncate yourdb.cache_entity_node? (y/n): y
Truncated yourdb.cache_entity_node.
Truncate yourdb.cache_entity_taxonomy_term? (y/n):