lowercase windows mysql tables became uppercase import to linux

Niceman2005 · 06-04-2006, 10:19 PM

Dear friends,

When I dump a mysql database from windows machine and then import the database in a Linux machine the letters for the tables became UPPERCASE in the linux machine. (the source was a windoes machine and the tables were lowercase..)

So the problem now is howcome the tables name turned from lowercase into uppercase after imported into linux machine...
any specific configuration i had done incorrectly?

Thanks for taking time helping...

Regards
Y

chrism01 · 06-05-2006, 08:24 PM

Check the dump file at each stage of the creation/txfr. Note that MSWin does not distinguish case, whereas Linux (Unix) does.

Niceman2005 · 06-06-2006, 02:18 AM

thanks chrism!