Thanks for your answer, Wiedmann.
You mean "my.cnf" (in "\xampp\mysql\bin")?
I had meant “my.ini,” actually, but do not anymore, now is the point I am confused, indeed about all these files / links, “my.ini”, “my.cnf”.
I have running two XAMPPs, one on “C:”, one on “H:”, there are existing (obviously) two “my.ini” or (or and?) two “my.cnf” per XAMPP shown in a file manager like here (I had found obviously three of these files, instead of four till today):
There is this my.cnf
Clicking on it seems to do nothing. Drag and drop the link shown on the screenshot above an editor being opened makes this / or a file editable and shows its content (how could I else open it?). Shown path in “Properties”: H:\xampp\mysql\bin.
I have linked three “my.cnf“ to a folder on the desktop for easier opening and after dropping such an icon over an editor, the editor shows this:
“my.ini” instead of “my.cnf”.
What does that mean? What did I do wrong?
---------------------------------------------------------------------------------------------------
I would like to have the same case (case sensitivity / lower or upper case), respectively keep it the way the cases are, as the scripts (e.g. Gallery, Drupal (with e.g. Drupal it works fine obviously) initialize them / apply to when installing the scripts. So I could install them on my local XAMPP and then upload keeping the cases (I assume). I would like all the scripts to be completely running on my local XAMPP and on the server, also (after uploading, not installing them on the server separately or modifying them after uploading). And going this way I would have a back up, always.
I assume (after having tried it) I have to add
- Code: Select all
lower-case-table-names=?
to a line below “[mysqld]” in the "my.cnf".
After adding “lower-case-table-names=0” and restarting XAMPP a warning was shown regarding the value “0”, so I didn’t go on as a precaution and especially after reading this:
Value Meaning 0 Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. Note that if you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result.
So, might I cause damage irreparably adding “lower-case-table-names=0” or another case?
Nice greetings, Dirk.