blocks|key|1650117|text|来自手册|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1650118|从MySQL+5.5.46开始，如果您试图在一个不区分大小写的文件系统上使用--lower_case_table_names=0启动服务器，则会打印一条错误消息，然后服务器退出。|blockquote|1650119|MariaDB也是如此。|1650120|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lower_case_table_names^0|2|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

From the <a href="https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_lower_case_table_names" rel="nofollow noreferrer">manual</a>:

<blockquote>
 As of MySQL 5.5.46, an error message is printed and the server exits
 if you attempt to start the server with --lower_case_table_names=0 on
 a case-insensitive file system.
</blockquote>

Same applies to MariaDB.

blocks|key|1650177|text|正如elenst所述，如果将lower_case_table_names设置为OFF或将lower_case_file_system设置为0，则可能会出现错误消息。该请求程序在lower_case_file_system系统上进行开发，但与许多系统一样，它部署在具有大小写敏感性的linux系统上，并且可能会出现兼容性问题，在开发过程中某些内容可能会正常工作，而在部署过程中则不会。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1650178|与流行的观念相反，Windows+(>+NT)允许区分大小写的文件系统，NTFS从一开始就支持区分大小写的文件，甚至可以(必须)在每个文件夹的基础上设置区分大小写的文件。干净利落。如果将mariadb上的数据文件(例如，mariadb\+data+)的位置和内容设置为区分大小写的行为，则在mysqld下，lower_case_table_name值在my.ini中可以设置为0。|1650179|lower_case_table_names+=+0|code-block|syntax|javascript|1650180|这是我的结果|1650181|select+@@lower_case_file_system,+@@lower_case_table_names;|1650182|在Windows+10系统上(运行wampserver，使用mariadb+10.4.10)：|1650183|%2B--------------------------%2B--------------------------%2B
%7C+@@lower_case_file_system+%7C+@@lower_case_table_names+%7C
%2B--------------------------%2B--------------------------%2B
%7C++++++++++++++++++++++++0+%7C++++++++++++++++++++++++0+%7C
%2B--------------------------%2B--------------------------%2B
1+row+in+set+(0.000+sec)|1650184|太完美了。|1650185|那么如何将数据文件夹设置为区分大小写呢？fsutil可以在创建文件后设置大小写感知标志。该命令如下：|1650186|fsutil+file+setcasesensitiveinfo+*data*+enable|1650187|数据取文件夹名的地方。有一个罪魁祸首，该命令不支持递归地设置所有子文件夹。一个简单的PS脚本会有这样的疑问：|1650188|Get-ChildItem+-Path+C:\wamp64\bin\mariadb\mariadb10.4.10\data+-Directory+-Recurse+%7C+foreach+{fsutil+file+SetCaseSensitiveInfo+$_.Fullname}|1650189|显然，您必须更改数据文件夹的路径，而不是我的路径。|1650190|备注:+MySQL工作台中的许多错误之一是，它不完全理解这一点，错误地假设lower_case_file_system=1在Workbench上运行时会抱怨服务器配置问题。|1650191|还有一句警告。虽然操作系统和FS支持的情况下，感觉到辉煌，许多应用程序不理解。但首先，您不应该将MySQL或MariaDB数据文件夹与其他应用程序混为一谈。|1650192|如果你遇到问题请告诉我。|1650193|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1D|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1E|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|1G|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1J|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1L|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1M|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|6|7|1O|8|@]|9|@]|A|$]]|$1|16|3|17|5|6|7|1P|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

Like elenst stated an error message might appear if setting lower_case_table_names to OFF or 0 on a system that has lower_case_file_system ON or 1. The asker develops on a Windows system but, as so many, deploys on a linux system that does offer case sensitivity and might run in to compatibility issues where something might work in developement but not in deployment.

Contrary to popular believe Windows (> NT) allows for case sensitive file systems and NTFS supports case sensitive files from its inception and case sensitive even can (must) be set on a per folder basis. Neat. If the location and content of the data files on mariadb (e.g. mariadb\data) is set to case sensitive behavior the lower_case_table_name value can be set to 0 in my.ini under [mysqld]. 

<pre><code>lower_case_table_names = 0
</code></pre>

Here is my result of 

<pre><code>select @@lower_case_file_system, @@lower_case_table_names;
</code></pre>

on a Windows 10 system (running wampserver, with mariadb 10.4.10:

<pre><code>+--------------------------+--------------------------+
| @@lower_case_file_system | @@lower_case_table_names |
+--------------------------+--------------------------+
| 0 | 0 |
+--------------------------+--------------------------+
1 row in set (0.000 sec)
</code></pre>

Perfect.

So the quenstion remains how to set the data folder to case sensitive? The fsutil can set the flag for case senstive to folders after the files where created. The command is as follows:

<pre><code>fsutil file setcasesensitiveinfo *data* enable
</code></pre>

where data takes a folder name. There is one culprit, the command does not support recursively setting all subfolders at once. A simple PS script does this wonder:

<pre><code>Get-ChildItem -Path C:\wamp64\bin\mariadb\mariadb10.4.10\data -Directory -Recurse | foreach {fsutil file SetCaseSensitiveInfo $_.Fullname}
</code></pre>

Obviously you will have to change the path to your data folder, not mine.

Remark: One of the many bugs in MySQL Workbench is that it does not understand this quite and assumes, wrongly, a lower_case_file_system=1 when on Windows and therefor complains about Server configuration Problems. 

And a word of caution. Although the OS and the FS suport case senstivity splenditly many application do not understand so. But you shouldn't be messing with your MySQL or MariaDB data folder with other application, in the first place.

Let me know if you do run in problems.

I have a test Linux server running the database for test, but locally I'm working on a windows. This means that my <code>lower_case_table_names</code> variable is set to <code>1</code>, so basically my table names case sensitive, whereas it's set to <code>0</code> by default on Linux.

I tried altering the variable in the <code>my.ini</code> located in my installation directory (<code>C:\Program Files\MariaDB 10.0\data\my.ini</code>). Before these changes apply, I do need to restart the service.

I went into my services and stopped the <code>MySql</code> service. Trying to start it again however, I get error:

<blockquote>
 1067: the process terminated unexpectedly
</blockquote>

So I suppose MariaDB cannot understand the <code>my.ini</code> configuration.

As I understood it by reading the documentation, this is one of the ways to actually do this. Removing the <code>lower_case_table_names</code> variable from the <code>my.ini</code> file, the service can start again.

How can I set the variable so my tables names are case-sensitive?

EDIT

Setting that variable to either <code>1</code>or <code>2</code> the service can start fine again.

Changing lower_case_table_names variable in MariaDB

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个测试Linux服务器运行数据库进行测试，但在本地，我正在运行一个窗口。这意味着我的lower_case_table_names变量被设置为1，所以基本上我的表名是区分大小写的，而在Linux上它被默认设置为0。我尝试更改安装目录( my.ini )中的变量(C:\Program Files\MariaDB 10...

问在lower_case_table_names中更改MariaDB变量
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在lower_case_table_names中更改MariaDB变量EN