--table regexp to accept negation (= exclude tables)

Bug #1651827 reported by Raphaël Droz on 2016-12-21
6
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!

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).

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1031

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers