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

Bug #1651827 reported by Raphaël Droz
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!

Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

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

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.