Checking Whether the Source and Destination Database Table Names Are Consistent in Case Sensitivity
MySQL Migration
Check Item |
Whether the source and destination database table names are consistent in case sensitivity |
---|---|
Description |
Check whether the source and destination database names and table names are consistent in case sensitivity. |
Failure Cause and Handling Suggestion |
Failure cause: This item cannot be checked because the source database fails to be connected. Handling suggestion: Check whether the source database is connected. |
Failure cause: Insufficient user permissions Handling suggestion: Check whether the database user permissions meet the migration requirements. |
|
Failure cause: The lower_case_table_names values in the source and destination databases must be the same. Handling suggestion:
|
|
Failure cause: The lower_case_table_names parameter value of the destination database is different from that of the source database, and the source database contains uppercase database and table names. Handling suggestion: Rectify the fault by referring to FAQs. |
|
Failure cause: The database is unavailable. Handling suggestion: Contact Huawei technical support. |
MySQL->MySQL, MySQL->Gauss(for MySQL) and Gauss(for MySQL) to MySQL Synchronization
Check Item |
Whether the source and destination database table names are consistent in case sensitivity |
---|---|
Description |
The destination database is case insensitive. The names of the mapped databases and tables contain uppercase letters. If the destination database is case-insensitive, all uppercase letters are converted to lowercase letters for storage. |
Failure Cause and Handling Suggestion |
Failure cause: The destination database is case insensitive. All uppercase letters are converted to lowercase letters for storage. The names of the mapped databases and tables contain uppercase letters. Handling suggestion: If the mapping relationship is correct, change the database and table names that contain uppercase letters to lowercase letters. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot