Bug #104382 mysqldump --ignore-table should accept some kind of wildcards
Submitted: 21 Jul 2021 14:52 Modified: 22 Jul 2021 7:09
Reporter: teo teo Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[21 Jul 2021 14:52] teo teo

Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times.

It's COMPLETELY OBVIOUS that this option should provide a way to specify some sort of pattern (at the very least wildcards such as *) so that you can ignore all the tables that match a given pattern.

If I want to ignore all the tables whose name starts or ends with or contains a given substring, which could be dozens, it's ABSOLUTELY RIDICULOUS that I have to specify all of them manually (also just not feasible in many cases where they are not known in advance).

How a person could think of an --ignore-table option without thinking about wildcards is beyond my understanding.

How to repeat:

Suggested fix:
implement wildcards or pattern matching for --ignore-table (perhaps call it --ignore-tables, plural)
[22 Jul 2021 7:09] MySQL Verification Team
Hello teo teo,

Thank you for the reasonable feature request!