Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5, 10.6
-
None
Description
mysqldump (mariadb-dump has options
--ignore-table-data=name
|
Do not dump the specified table data. To specify more
|
than one table to ignore, use the directive multiple
|
times, once for each table. Each table must be specified
|
with both database and table names, e.g.,
|
--ignore-table-data=database.table.
|
--ignore-table=name Do not dump the specified table. To specify more than one
|
table to ignore, use the directive multiple times, once
|
for each table. Each table must be specified with both
|
database and table names, e.g.,
|
--ignore-table=database.table.
|
Both options are case-insensitive. That is, if we have tables test.A and test.a, then mysqldump ... --ignore-table=test.a will skip both tables, and so will mysqldump ... --ignore-table=test.A.
This is not universal for mysqldump options. For example, mysqldump ... test --tables A will only dump the table test.A, and mysqldump ... test --tables a will only dump the table test.a. So, treating ignore-table differently is inconsistent.