Add easier default option to exclude data from typical tables

Created on 27 February 2024, 4 months ago

Problem/Motivation

Since Drupal 6 (or even before) ;) there are certain database tables / table-namespaces that you typically always want to exclude from your backups to not become XXL, like:

  • {db-prefix-}batch
  • {db-prefix-}cache_*
  • {db-prefix-}semaphore
  • {db-prefix-}search_api_db_*
  • {db-prefix-}sessions
  • ...?

But the current option to manually exclude these by selecting these in the "Exclude data from these tables" <select> is not very user-friendly and you need deeper knowledge about these tables.

Steps to reproduce

Run a backup on a Drupal page with large cache, many many sessions or search_api_db tables and be frustrated because the backup fails or is super large.

Proposed resolution

In the first step, we could at least list the typical tables that should be excluded in the field description in the settings
In the next step, it would be better to have a setting (enabled by default for new installations) to exclude these typical tables. Maybe we could have a checkbox for each typical case.

The major difference to the select is, that you don't need to select (and update) the tables to be excluded, as these are determined dynamically based on the prefix.

Remaining tasks

  1. Discuss
  2. Implement
  3. Test
  4. Release

User interface changes

API changes

Data model changes

✨ Feature request
Status

Active

Version

5.1

Component

Code

Created by

πŸ‡©πŸ‡ͺGermany Anybody Porta Westfalica

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.69.0 2024