Today, migrating a database from SQL Server to Linux MySQL, the migration is successful, but the application is not running, viewing the log discovery, the prompt to find the table, I noticed that the table names are case, and the table names in MySQL are lowercase. This reminds me, is it not MySQL
The table name is case-sensitive? That's how it looked. The solution is as follows:
1. Log in with root, modify/ETC/MY.CNF
2. Add a line under [mysqld]: Lower_case_table_names=1
3. Restart the database to
Where the Lower_case_table_names=1 parameter defaults to 1 in Windows, 0 in Unix, so there is no problem in window, The reason for the problem (especially when MySQL does not use uppercase letters when naming a table, and the error that the query uses the capital letter but will not be able to find it), is confusing.
From: http://hi.baidu.com/stormagic/item/dae8a5b5f822b8eb4fc7fd9e