在Windows Xampp上哪里更改lower_case_table_names = 2的值 [英] Where to change the value of lower_case_table_names=2 on windows xampp

问题描述

我正在使用Windows 7和xampp，我正在尝试导出数据库，而在此过程中，表名将转换为lower case.我进行了很多搜索，我知道我必须将lower_case_table_names的值从0更改为2，但是在哪里必须更改此值，在哪个文件中?

I am using windows 7 and xampp i am trying to export my database and while in the process the table names are converted to lower case. I have searched a lot, i know i have to change the value of lower_case_table_names from 0 to 2 but where i have to change this value, in which file?

推荐答案

执行以下步骤:

1. 打开您的MySQL配置文件:[驱动器] \ xampp \ mysql \ bin \ my.ini
2. 查找以下内容:# The MySQL server [mysqld]
3. 在其下面添加此名称:lower_case_table_names = 2
4. 保存文件并重新启动MySQL服务

1. open your MySQL configuration file: [drive]\xampp\mysql\bin\my.ini
2. look up for: # The MySQL server [mysqld]
3. add this right below it: lower_case_table_names = 2
4. save the file and restart MySQL service

来自: http://webdev. issimplified.com/2010/03/02/mysql-on-windows-force-table-names-to-lowercase/

这篇关于在Windows Xampp上哪里更改lower_case_table_names = 2的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！