drush-ops / drush

Drush is a command-line shell and scripting interface for Drupal, a veritable Swiss Army knife designed to make life easier for those who spend their working hours hacking away at the command prompt.
https://www.drush.org
2.33k stars 1.08k forks source link

structured-tables-key is skipping tables entirely #626

Open kayakr opened 10 years ago

kayakr commented 10 years ago

If I use drush sql-dump --ordered-dump --structure-tables-list="cache,cache_*" or drush sql-dump --ordered-dump --structure-tables-key=caches, when drushrc.php has

$options['structure-tables'] = array(
  'caches' => array(
    'cache',
    'cache_*',
  ),
);

I find the resulting dump has cache* tables missing entirely, rather than including the table structure with no data. Drush 7.0-dev.

weitzman commented 9 years ago

Still broken?

ElijahLynn commented 7 years ago

I am having this issue now with 8.1.9.

I have tried a 3 different ways:

  1. In drushrc.php $command_specific['sql-sync'] = array('structure-tables-list' => 'accesslog, batch, cache, cache_*, ctools_css_cache, ctools_object_cache, flood, search_*, history, queue, semaphore, sessions, watchdog, webform_submitted_data');
  2. Drush CLI --structure-tables-key=common and this in drushrc.php $options['structure-tables']['common'] = array('accesslog, batch, cache, cache_*, ctools_css_cache, ctools_object_cache, flood, search_*, history, queue, semaphore, sessions, watchdog, webform_submitted_data');
  3. Drush CLI with --structure-tables-list='accesslog, batch, cache, cache_*, ctools_css_c ache, ctools_object_cache, flood, search_*, history, queue, semaphore, sessions, watchdog, webform_submitted_data'

When doing a sync in verbose mode with 1 and 3 above it shows Starting to dump database on Source. ... sql-dump --structure-tables-list='\''accesslog, batch, cache, cache_*, ctools_css_cache, ctools_object_cache, flood, search_*, history, queue, semaphore, sessions, watchdog, webform_submitted_data'\'' --gzip --result-file 2>&1' 2>&1

and only the first table is ever empty (structured).

Any ideas?

ElijahLynn commented 7 years ago

Ahh, my issue appears to be that I was using spaces :/