I can’t see how it would but I wanted to get the opinion of some people who know about MySQL better than I do.
I inherited a website which was built using PHP/MySQL on a windows server. The developer had used a mix of upper/lower case table names and not always typed them the same way in the PHP code. I need to move this site to our linux webserver. Obviously, I can go through and check/change every query which would be rather time consuming. The other option appears to be setting lower_case_table_names to 1 ( http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html )
There are other existing websites on the server which adhere correctly to case sensitivity (mostly, the table names are all lowercase). My question is, is setting lower_case_table_names to 1 likely to have any negative impacts on the existing sites? On inspection it appears that this shouldn’t break anything or cause any problems, but from experience I know that these kind of changes can create unforeseen knock on effects.
Are there any pros/cons regarding lower_case_table_names. If there’s no negatives, why isn’t it on by default?
Cheers!