Sample Header Ad - 728x90

MariaDB installation setting lower_case_table_names

0 votes
1 answer
61 views
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