Anyone have a work-around for case sensitive database and table names?
E.g. you can reference the database in both upper and lower case.
For reference the server is running FreeBSD and it's MySQL version 3.23.56
Printable View
Anyone have a work-around for case sensitive database and table names?
E.g. you can reference the database in both upper and lower case.
For reference the server is running FreeBSD and it's MySQL version 3.23.56
Check out this page from the MySQL docs. There is a lower_case_table_names options to control this (dunno if it's supported in 3.23). If you set it to 1, you will need to stop MySQL and rename your files and directories to lowercase first.
Thanks!