I have installed vanilla 0.9.2.6 on two different machines. On one, the DB tables went in as all lowercase (e.g. lum_role). But on the other machine, the table names are consistent with the convention in database.sql (LUM_Role). During development, I would like to export (dump) individual tables from one to the other from time to time, but I can't because the tables are named differently.
Which way are they supposed to be? Does it matter? If so, is there a way (beside manually renaming one set) to make sure they install one way or another?
Let me guess, the lowercase one is on a windows machine?
I have the same problem, and I've googled for days trying to figure out how to make mysql keep the text-case intact on windows, but I've never been able to accomplish.
Now it has become a point of contention for me - where I refuse to bend to the flaw on windows that causes this to happen. I want to have my mixed case naming conventions.
If anyone comes up with a solution, please tell me about it.
hmm, the easiest solution would be to just name the tables to all lowercase (don't hit me!). However, this could be some bug in mySQL on windows for all we know, perhaps a switch or something isn't properly set somewhere for all we know. I'll google around for a solution.
I set the lower_case_table_names to 2 on my windows machine and expected everything to break, but so far nothing has. I'll have to tinker with it more when I'm properly awake.
Kosmo, it's a bit of both, as on windows, AA = aa, while on most *nix and other variants, AA != aa and so on. So, I suspect someone over at mySQL didn't think it would affect anyone so they left it at a default state and left it up to the system it's running upon to decide which to use. Hopefully in current-coming and later builds they'll clean this up somehow, because it's an obvious annoyance.
mark, once you're set, run mySQL and php through some kind of benchmark and see if there's any warning lights that pop up. The one thing that suprises me is how it will lower case the table names but not everything else.