如何将MySQL从Windows迁移到Linux

weixin_33895604

于 2017-09-19 10:16:08 发布

阅读量235

点赞数

文章标签：数据库

原文链接：http://blog.51cto.com/l0vesql/1966567

版权

本文介绍了 MySQL 中 lower_case_file_system 变量的作用，该变量决定了数据目录所在文件系统的文件名大小写敏感性。当设置为 OFF 时，文件名区分大小写；设置为 ON 时，则不区分大小写。此变量只读，反映文件系统属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

表名问题

lower_case_file_system

System Variable	Name	`lower_case_file_system`
	Variable Scope	Global
	Dynamic Variable	No
Permitted Values	Type	boolean

This variable describes the case sensitivity of file names on the file system where the data directory is located. OFF means file names are case sensitive, ON means they are not case sensitive. This variable is read only because it reflects a file system attribute and setting it would have no effect on the file system.

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names

转载于:https://blog.51cto.com/l0vesql/1966567