Showing entries 1 to 2
Displaying posts with tag: lower_case_table_names (reset)
Install MySQL 8 on Linux with lower_case_table_names = 1

Tweet

MySQL stores several files on disk. Even in MySQL 8 where the data dictionary is stored in InnoDB tables, there are still all the tablespace files. Different file system behave differently, and one particular challenge is case sensitivity. On Microsoft Windows, the case does not matter, on Linux the case is important, and on macOS the case of the file names is preserved but the operating system by default makes it look like it is case insensitive.

Which convention that is the correct depends on your personal preference and use case. Between case sensitivity and case insensitivity, it basically boils down to whether mydb, MyDB, and MYDB should be the same identifier or three different ones. Since …

[Read more]
Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy

Do you ever need to transfer databases between servers? Different OSes? Two common ways of data migration: 1. Create mysqldump and load it. 2. File transfer using SCP. Case Sensitivity and Issue: Yes, that can create big issues when you have to deal with systems having different case sensitivity. E.g. on linux you can create directories with names “Kedar” or “kedar” which is not possible on windows! It will be harmful when file-system itself restricting the names to lower case. MySQL has a variable for that: lower_case_file_system. Documentation says: This variable describes the case sensitivity of file names on the...

The post Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy first appeared on ..::CHANGE is …

[Read more]
Showing entries 1 to 2