MySQL Forums
Forum List  »  MyISAM

Re: Capital Table Name format
Posted by: denpsia
Date: November 03, 2005 10:15PM

Hi Ingo and everybody,

The problem is that when executing mysqldump to dump client data and insert data to server using mysql command, it created another table with name of table all in small caps. Example:
Server Table Name: MyTable
Created New Table Name at server after exceuting the batch file: mytable

Do i need to change all my codes regarding the case-sensitive table name all to loer caps which is a lot and change also entire server tables to small caps also? Or there is a shorter much easier way to do this. What does mysqld command do? Setting the lower_case_table_names would solve my problem without changing table (by re-creating them) at server or change my programming codes from "MyTable" format to all small caps format? AnyBody? Thanks.

How exactly to use mysqld to change the system varibale lower_case_table_names?

I tried executing this statement "mysqld --lower_case_table_names==2 " it is not working at local database. How could I change this setting on server from local computer? Anybody? Thanks

Error Message:
051104 13:00:45 [ERROR] Can't find messagefile 'C;\mysql\share\english\errmsg.sys'
051104 13:00:45 [ERROR] Aborting



denpsia



Edited 3 time(s). Last edit at 11/03/2005 11:06PM by denpsia.

Options: ReplyQuote


Subject
Views
Written By
Posted
4839
November 02, 2005 01:15AM
2061
November 02, 2005 06:04AM
2338
November 02, 2005 07:06PM
2644
November 03, 2005 03:18AM
Re: Capital Table Name format
7004
November 03, 2005 10:15PM
2976
November 04, 2005 04:08AM
2772
November 06, 2005 07:11PM
2894
November 07, 2005 04:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.