Re: Cannot open tables from the internal data dictionary

[Jason Carley]

I think I may have figured out the problem, but I don't know how to fix it. The table names are stored inside the ibdata1 file with both upper and lower case characters. Since I can only have lower case table names on windows, it can't find the table in the ibdata1 file. I tried going into the ibdata1 file and changing the upper case table characters to lower case, but mysql had a bit of a fit when pointed to that file (checksum errors / reports of corruption). I tried modifying the "lower case table names" variable between 0, 1, and 2 and unfortunately it doesn't seem to have any impact on already stored tables. Any suggestions? Unfortunately I can no longer access the linux machine that use to be running it. Thanks for your help.