Bug #69311 mysqldump with ignore-table does not consider case senstive table names

• Submitted: 23 May 2013 12:31
• Modified: 23 May 2013 13:04
• Reporter: Oli Sennhauser
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S3 (Non-critical)
• Version: 5.5.31
• OS: Linux (n.a.)
• CPU Architecture: Any
• Tags: ignore-tables, mysqldump

[23 May 2013 12:31] Oli Sennhauser

Description:
Dumping a MySQL database with 2 tables with the same name but different cases (upper/lower) cannot be distinguished by the mysqldump utility using the --ignore-tables option.

How to repeat:
show tables;
+----------------+
| Tables_in_test |
+----------------+
| Test           |
| test           |
+----------------+

select * from Test;
+----+-----------------+------+
| id | data            | ts   |
+----+-----------------+------+
|  1 | upper case test | NULL |
+----+-----------------+------+

select * from test;
+----+-----------------+------+
| id | data            | ts   |
+----+-----------------+------+
|  1 | lower case test | NULL |
+----+-----------------+------+

mysqldump -u root --no-create-info --ignore-table=test.test test > /tmp/t1.sql
mysqldump -u root --no-create-info --ignore-table=test.Test test > /tmp/t1.sql

Suggested fix:
mysqldump --ignore-table should be case sensitive

[23 May 2013 13:03] MySQL Verification Team

Hello Oli,

Thank you for the report.
Verified as described.

Thanks,
Umesh