This affects all profile types, manual or scheduled, whenever we add new modules or some module updates have schema updates with new tables.

As it also is relevant to scheduled backups, I find it extra important to find a solution.

Lets say we have a profile that backs up all tables, but excludes the DATA for only the cache tables, and backs up all the rest with both table definitions and data.

Whenever we have a new module that adds more cache_ tables, the subsequent backups will start backing up those cache tables as the Backup_Migrate module does not have a dynamic update of profiles based on table name patterns.

Can it be possible to add a feature to the "include" list and the "exclude data from the following tables" function, where we can specify patterns in a body text field, just like we do with block visibility settings exeptions?

For example, I would like to be able to specify the following pattern:

Include data from the following tables:
* (all, including any new tables that occur later, dynamically included without manually updating the various backup profiles)

Exclude data from the following tables:
search* (all tables starting with the letters 'search', also working automatically for new ones that comes with future modules)
cache* (all tables starting with the letters 'cache', also working automatically for new ones that comes with future modules)

Or on the contrary: when making "structure-only" backups:
- Include data from the following tables:
(no selections, none will be included by default after new modules are installed either)

- Exclude data from the following tables:
* (all, making sure that also all new/future tables will be included in structure-only backups after new modules are enabled, without needing to manually update any backup profiles)

Comments

izmeez’s picture

1+ for this feature request, especially to exclude data from all cache* tables including new ones added.

couturier’s picture

Status: Active » Closed (outdated)

Cache data is now excluded by default in the 7.x branch, and there is a request to have the same for the 8.x branch.