I had MySQL installed on Windows 11 with lower_case_table_names=2 to preserve mixed-case table names. To migrate to MariaDB, I backed up the database with mysqldump. When installing MariaDB using either the MSI package, or the ZIP, it seems that mariadb-install-db.exe creates the my.ini file in the data folder with lower_case_table_names=1, and it cannot be changed afterwards.
I tried deleting the content of the data folder, creating a my.ini in the MariaDBroot and manually rerunning the mariadb-install-db.exe, but it ignores that ini file.
MySQL installation asks the question as to what the lower_case_table_names setting should be during set up, but not MariaDB.
When restoring the database from the dump into MariaDB, SHOW TABLES lists the tables all in lower-case.
Other sites and MariaDB documentation say that the lower_case_table_names=2 settings is supported, but not how to achieve that. Does anyone know how lower_case_table_names can be set to 2?
Asked by Peter Brand
(111 rep)
Jun 19, 2025, 10:32 PM
Last activity: Jun 20, 2025, 03:24 PM
Last activity: Jun 20, 2025, 03:24 PM