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
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[21 Jul 2021 14:52] teo teo

Description:
"""""
--ignore-table=db_name.tbl_name

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!

regards,
Umesh