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 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the Case Sensitivity of the Destination Database Is Configured

Check whether the value of lower_case_table_names in the destination database meets requirements. If the value of lower_case_table_names is 1, the database and table names are case insensitive. The databases or tables whose names contain uppercase letters cannot be migrated.

Failure Cause

The value of destination database parameter lower_case_table_names is 1, and the names of the selected databases or tables contain uppercase 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 an RDS instance, modify the parameter on the RDS management console. If the modification fails, contact customer service.
Parent topic: Database Parameters