Hi. Windows filesystem is not case sensitive.
See: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I apologize for the missing information. > First the server was on 4.0.20 now on 4.0.22. Apache > 1.3.x not sure of the linux > The local machine is windows xp with mysql v. 4.0.20a > I did the data transfer running Navicat, so that may > not be so clear to anyone, but the only options that > were enabled: > > 1-Create tables > 2-Indclude all table create options > 3-Create records > > They were transfered directly to the server. > The tables are all fine ,outside of when they came to > the windows machine all lowercase on the table names. > I can rename them on the windows machine using upper > case. > > I guess I'm still trying to figure out how the > database got hosed anyway (still awaiting answer from > web host). > One possible guess is that most of my tables are > Innodb. Not sure why , but perhaps its related. > > Stuart > > > --- mysq > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]