Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Case Sensitivity of the Destination Database Is Configured
Updated on 2022-07-19 GMT+08:00
View PDF
Share

Checking Whether the Case Sensitivity of the Destination Database Is Configured

Synchronization from TiDB to GaussDB(for MySQL)

Table 1 Case sensitivity check for the destination database

Check Item

Case sensitivity check for the destination database

Description

Destination database parameter lower_case_table_names check

Failure Cause and Handling Suggestion

Failure cause: The value of destination database lower_case_table_names is 1, and the names of the selected databases or tables contain uppercase and lowercase letters.

Handling suggestion: If the destination database is a self-built database, add lower_case_table_names=0 under [mysqld] in the MySQL configuration file my.cnf and then restart the destination database.

If the destination database is a cloud database, check whether the lower_case_table_names parameter can be modified. If it cannot be modified, contact customer service. If the destination database is an RDS database, you can modify the parameter on the RDS console.
Parent topic: Database Parameters