Preserving case on Win32 table names

Hi All

Found that when I executed my DDL script on a Win32 installation of MySQL
(v4.0.18) it converted all of my table names to lowercase.

The problem was that after I had filled the newly created DB with content,
backed it up and then restored it into my ISP's unix version of MySQL my web

app couldn't use any of the tables because I was querying them in UCase and
all of the tables were in LCase.

Thinking this was a fault with the MySQL Admin prog, I reported it as a bug,

but then after their support found that it was my Win32 installation that
was causing the LCase issue they wouldn't go into depth on the best method
to make my Win32 installation leave the case alone.

All I have from them is that I should specify the
lower_case_table_names='xx' command, but I don't if I should:

a) Put this command somewhere in my 'my.ini' file. If so, where?

b) What parameter should I specify for 'xx' to ensure that the above will
work OK. A couple of horror stories on the
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html page stated
that if you get this wrong you could corrupt various areas of your DB.

Your help would be very much appreciated.

Rgds

Robbie



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Preserving case on Win32 table names

You can use lower_case_table_names=1 at your .cnf or .ini file, at
your server section (usually [mysqld]), this will make the Server
ignore case on table names, that is trully a win32 compatibility
feature, because that's the only OS that by default hide the case for
filenames at their file manager (explorer), at least on 95/98, wich is
pretty stupid and make our (developers) lifes harder. Your file wil
contain something like this:

[mysqld]
lower_case_table_names=1

If you're afraid on corrupting data, Back it all up before any action,
then you'll be safe to deal with it. I've never heard any horror tale
about this config, will check your link after sending this, lol.

If you want a better option, go to your Folder Options at Explorer and
check the option related to "Allow UpperCase File names" (something
like that), then you'll see their names at the file manager with their
real case.

--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org