Apache Friends Support Forum

I tried setting lower_case_table_names = 1 in /opt/lampp/etc/my.conf. I am using XAMPP 1.7 on Ubuntu 9.04 server

After several attempts and restarts the variable doesn't seem to take effect. I queried using

mysqladmin -u root variables | grep "lower_case_table_names"

and get the output 0

I am planning to switch to mysql from Ubuntu repo but before that wanted to check if I am missing something or is this a bug. The documentation of XAMPP suggests this is the right conf file.

I tried setting lower_case_table_names = 1 in /opt/lampp/etc/my.conf.

I don't think "my.conf" is the correct file. IMHO it is "my.cnf".

And you must add this to the correct section in this file.

Ouch! I did mean my.cnf even though I ended up writing my.conf... Typo ... thanks for pointing out.

You mention the right section.. Can you throw some pointers? I just added it to the end of the file.

Thanks

I think the correct section hint was very useful. I just moved it under MySQL server section and things worked

Even though I had read through this section it didn't strike me that the location would matter.

Many Thanks