Exclude cache table contents by default

You should exclude the cache data with selecting all cache-related tables. That can be done when you add a new/edit an existing settings profile at /admin/config/development/backup_migrate/settings. And then exclude the cache table data in the select field called Exclude data from these tables
.

When you use that settings profile for your exports, you don't need to flush the caches in the production system anymore and your backups should be drastically smaller.

This should be the default (as it was in previous versions) updating issue to reflect that.

Updating the version.

The patch excludes the default cache tables by default and use them also as default excluding tables when creating a new profile.

Probably we should also include table "cache" ?
Also I don't see "cache_block" in the list.

Do you find those tables in Drupal8? I cannot see them in my installation.

I would exclude everything identified thusly (7.x):

  $core = array('cache', 'cache_path', 'cache_filter', 'cache_bootstrap', 'cache_page');
  $cache_tables = array_merge(module_invoke_all('flush_caches'), $core);

It's a good idea, but I cannot find a way to clearly identify the cache table names. I stuck in

$module_handler = \Drupal::moduleHandler();
$module_handler->invokeAll('cache_flush');
foreach (\Drupal\Core\Cache\Cache::getBins() as $service_id => $cache_backend) {
  // There are useful information in $cache_backend, but only protected and not accessible.
}

but cannot extract the necessary CacheBackend information out of it. (Also not all `cache_*` tables were present in that loop.)

I've managed to identify the following tables that shouldn't export any data.
If anyone knows different please feed back.

      $config = [
        'exclude_tables' => [],
        'nodata_tables' => [
          'cache_advagg_minify',
          'cache_bootstrap',
          'cache_config',
          'cache_container',
          'cache_data',
          'cache_default',
          'cache_discovery',
          'cache_discovery_migration',
          'cache_dynamic_page_cache',
          'cache_entity',
          'cache_menu',
          'cache_migrate',
          'cache_render',
          'cache_rest',
          'cache_toolbar',
          'sessions',
          'watchdog',
          'webprofiler',
        ],
      ];

Longer term we'll probably need a more elegant solution to this issue but for now we'll have to go with it.

Slightly modified version of patch in #5 pushed to dev.

Would like to reopen this issue to add the tables "cache_page" and "cachetags" for excluding by default. what do you think about?

@dercheffe Since this patch has been committed last year, I'm not sure the procedure. Can someone advise as to whether we should open a new issue for this?

@dercheffe I created a follow-up: #3548593: Add a setting to *dynamically* exclude data from cache tables and other unwanted sources