RE: lower_case_table_names issue

2001-06-27 Thread sean . odonnell
>From my experiance, you cant, you can use all table names lowercase, but that will mean you will have to refer to them in lowercase when issuing queries. unix, unlike windows, tends to operate in a case sensitive manner on everything -Original Message- From: Rui Rosa [mailto:[EMAIL PROTE

Re: lower_case_table_names issue

2001-06-26 Thread Gerald R. Jensen
Did you convert the table/column names to lower case? If "lower_case_table_names is=1" MySQL will convert all table names to lower case on storage and lookup ... but you need to first convert your old table names to lower case before starting mysqld. If you have not done so, you should run an ALT