I have dev MySQL 5.7.19 installed locally (Windows 10 x64) with lower_case_table_names=2 in my.ini (for better compatibility with our prod *nix environment, this setting is NOT default for windows version of MySQL).
I have table and column names: Table, Table.Id, etc. With the setting for table 'Test' there are files 'Test.frm' and 'test2.ibd' on disk.
Dumping database using HeidiSQL worked fine until 9.5.0.5199 (it works in 9.5.0.5198 and before). In 9.5.0.5199 and above it shows errors for the tables with capitalized names: "Could not find table or view <db>.<lowercased table name>. Please refresh database tree." With lowercased table names all works fine.
How to reproduce:
- Add lower_case_table_names=2 into my.ini and restart MySQL (could be tricky if you already have databases)
- Run HeidiSQL 9.5.0.5199 or above
- Create database test
- Create tables in the database use simple script:
CREATE TABLE test1 (Id INT); INSERT INTO test1 (Id) VALUES (1); CREATE TABLE Test2 (Id INT); INSERT INTO Test2 (Id) VALUES (2);
Notice lowercased table name for one table and capitalized table name for another table.
- Refresh database tree
- RMB over database 'test' | 'Export database as SQL' | enter filename | 'Export'
- Notice that table 'test1' dumped successfully, but 'Test2' -- not. In error message HeidiSQL will show incorrect table name test.test2 (lowercased, should be test.Test2).
- Install HeidiSQL 9.5.0.5198 and check that the database dumped successfully.
Two screenshots attached (for HeidiSQL versions 9.5.0.5199 and 9.5.0.5199)
Thanks.