Cannot Rename Tables To A Name With Different Case

[motin]

I am getting rather annoyed at this inconveniance:

I just cannot rename tables to names with both upper and lowercase letter, for example “tblMembers”. Everytime I try, through the GUI, the query window or importing a .sql-file, the table's name becomes “tblmembers”.

This makes it impossible to synchronize with my linux webhost (connecting through ssh btw)!

I thought I found the answer when I found the “lower_case_table_names” setting, and has now set it to equal 2 on my Windows development machine, while I guess it is default 0 on the Linux-box. But this makes no difference in the behavior.

Is this a SQLYog 4.1-bug or a problem that cannot be solved, regarding MySQL 4.1, you think?

Please help… Thanks.

[peterlaursen]

Looks very much like this one:

http://www.webyog.com/faq/26_25_en.html

It should solve the issue to upgrade to MySQL 4.1.13 or higher.

… and use the server directive lower_case_table_names=2 in the [mysqld] section of the my.ini -file.

[peterlaursen]

You can also use 'MySQL Administrator'

The meaning of 0,1 and 2 for this directive is explained in attached screenshot.

[motin]

peterlaursen wrote on Jan 17 2006, 12:18 AM:

Looks very much like this one:

http://www.webyog.com/faq/26_25_en.html

Yes indeed it does, although all my tables

are MyISAM, not InnoDB.

peterlaursen wrote on Jan 17 2006, 12:18 AM:

… and use the server directive lower_case_table_names=2 in the [mysqld] section of the my.ini -file.

So I have. Thanks for clarifying.

peterlaursen wrote on Jan 17 2006, 12:18 AM:

It should solve the issue to upgrade to MySQL 4.1.13 or higher.

Despite having MyISAM-tables this seems to be my best bet. Thanks!

I'll return to this post with success-status…

[peterlaursen]

With MyISAM tables I think the directive will work also with MySQL < 4.1.13. That is how I read the docs. Am I wrong? If you are sure to have experienced that it is the same with MyISAM I'll change the FAQ accordingly.

[motin]

motin wrote on Jan 17 2006, 03:27 PM:

I'll return to this post with success-status…

[post=”8492″]<{POST_SNAPBACK}>[/post]

No success. Upgrading to 4.1.16 did not solve the problem.

I found another way to rename the case though: renaming the files from MySQL-data directory. This will make the file-names correct. I am not sure how this affects indexes etc, but this seems to be me best bet as every ALTER or CREATE command converts everything to lowercase…

I want to verify that my lower_case_table_names-setting has kicked in, do you know a way to do this at runtime? (Google isn't much helpful this time… Nor is the MySQL-documentation search)

[peterlaursen]

For server directives to take effect the Server must be restarted.

Messing around with the MySQL files the way you do is not wise!

[Ritesh]

As Peter suggested, you need to restart the MySQL server. Did you do that?

[Author]

Posts