lower_case_table_names

Aikesheng Open Source Community

Jul 6, 2023 · Databases

Impact of MySQL lower_case_table_names on DTLE Data Synchronization

This article investigates how differing MySQL lower_case_table_names settings between source and target affect DTLE's ability to synchronize data, presenting test scenarios, observed behaviors, and recommendations for configuration and job management.

DTLEData SynchronizationMySQL

0 likes · 10 min read

Impact of MySQL lower_case_table_names on DTLE Data Synchronization

Aikesheng Open Source Community

Jan 9, 2023 · Databases

MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies

The article analyzes a MySQL mysqldump failure where tables appear missing due to the lower_case_table_names setting, reproduces the issue through a controlled experiment, and provides practical solutions and operational recommendations for handling case‑sensitivity during database migrations.

LinuxMySQLTroubleshooting

0 likes · 7 min read

MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies