I have a remove server with tables such as CAPS_TABLE on my local machine I have PHPMyAdmin installed a credited a table but it always make them in lower case. how can i change this?
Sounds like the lower_case_table_names setting.
thats it. how do i change it?
NZ_Kiwis;10933547 wrote:thats it. how do i change it?
I think you'd have to change it in the my.ini file and then restart MySQL.
there is nothing in the my.ini about tables
If it's Windows, then try adding this to the my.ini:
lower_case_table_names=2
If it's Windows, then it doesn't matter what case the name of the table is in (as per the SQL standard); it's when the filesystem uses case-sensitive filenames that MySQL treats table names case-sensitively (yeah, brilliant design, that....)
