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 Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:5.5.31 OS:Linux (n.a.)
Assigned to: 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