--table regexp to accept negation (= exclude tables)
Bug #1651827 reported by
Raphaël Droz
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.3 |
Triaged
|
Wishlist
|
Unassigned | |||
2.4 |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
Currently the --table option accept a regexp.
Although its format isn't documented anywhere it currently does not accept pattern negation.
It means it only allow specifying a white-list of table rather than blacklisting tables based on a pattern.
But the later is very useful in the real-life. Ex: excluding table matching '^(cache|log)'.
Could you consider improving the regexp engine so that perlre could be used, or alternatively accept another --exclude parameter.
Side note: in many use case, having the possibility to dump table structure (no-data) for a regexp-defined subset of table is also very useful.
Best regards and thank for the great work!
To post a comment you must log in.
xtrabackup is using posix regex syntax. It is true that it doesn't allow to negate the pattern.
We consider adding --exclude option, or another possibility to add --invert-match -like option (similar to grep -v).