Table Names Lose Uppercase When Copied From Linux Mysql To Wamp Mysql

[mbabineau]

So I ran into an interesting problem. I've got LAMP setup in production and WAMP setup for local development. When I copy my database from production to local, it loses all the uppercase letters in the table names. This as you can imagine causes some problem, but only when you try to push the database back to the linux mysql server. Either way, its very annoying and I'm wondering if this is a bug or is it a result of mysql on windows and its inability to handle uppercase characters in table names?

Example:

AccountSettings on LAMP turns into accountsettings on WAMP.

Any help would be appreciated.

[sathish]

Hello,

Its the MySQL server that modifies the letter case. The behavior can be controlled by setting lower_case_table_names.

Please execute SHOW VARIABLES LIKE 'lower_case_table_names'; and compare the result with the documentation given here.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Refer http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names to see how you can set this variable to match your requirements.

However it is advised to use this variable set to 1 in case insensitive file systems and use only lowercase to name your database and tables for maximum portability. In short, MySQL recommends the use of delimiter_separated naming convention over CamelCase naming convention.

Regards,

Sathish

[mbabineau]

Ok, that makes sense. I'll just convert everything to lower case with “_” separators…..that will solve my problem!

Thanks,

Matt

'sathish' wrote:

Hello,

Its the MySQL server that modifies the letter case. The behavior can be controlled by setting lower_case_table_names.

Please execute SHOW VARIABLES LIKE 'lower_case_table_names'; and compare the result with the documentation given here.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Refer http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names to see how you can set this variable to match your requirements.

However it is advised to use this variable set to 1 in case insensitive file systems and use only lowercase to name your database and tables for maximum portability. In short, MySQL recommends the use of delimiter_separated naming convention over CamelCase naming convention.

Regards,

Sathish

[Author]

Posts