Bug #108260 Data Export fails (showing no tables) when schema name contains uppercase
Submitted: 23 Aug 2022 20:17 Modified: 14 Sep 2022 15:26
Reporter: Jack Parker Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:8.0.30 OS:Any
Assigned to: CPU Architecture:Any

[23 Aug 2022 20:17] Jack Parker
Description:
In case https://bugs.mysql.com/bug.php?id=103572 was CLOSED as "not repeatable"
Please take another look.

It is now easily repeatable.

The Data Export wizard fails to find tables of a schema that contains any uppercase letter.

So "dummyDb" or such will fail; while "dummydb" will work as expected.

How to repeat:
Create a schema/database with an uppercase letter in the name (dummyDb)

Click to "Data Export" in the Administration panel.

Select the "dummyDb"

Observe that no tables are found.

Suggested fix:
Likely something in the Wizard is downcasing the schema name,
and using that modified name to locate the tables... [?]

Workaround: using commandline mysqldump
[23 Aug 2022 20:24] Jack Parker
a schema that works

Attachment: schema1.sql (application/octet-stream, text), 2.57 KiB.

[23 Aug 2022 20:24] Jack Parker
a Schema that fails

Attachment: Schema2.sql (application/octet-stream, text), 2.57 KiB.

[14 Sep 2022 7:11] MySQL Verification Team
Hello Jack Parker,

Thank you for the bug report.
Imho this is duplicate of Bug #103783, please see Bug #103783.

Regards,
Ashwini Patil
[14 Sep 2022 15:26] Jack Parker
Thanks.
I've added that note also to Bug #103572