如何将MySQL从Windows迁移到Linux

  1. 表名问题

    

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