Casesensitive tablenames with MySQL on Linux

Aus MHC-Wiki

Wechseln zu: Navigation, Suche

Case sensitive talblename on Linux

Tabelname in MySQL on Linux are casesen sitive. On Winodws and Mac OS X they are not. To make table names not case sensitve add the following line to my.cnf in the [mysqld]: 

lower_case_table_names = 1

VCS

If you have a omnis VCS created without "lower_case_table_names = 1" and then switch to "lower_case_table_names = 1" VCS will no loger work. The workaround is:

  • dump the VCS DB without "drop table" and "create" statements
  • switch to "lower_case_table_names = 1"
  • create a new DB
  • log on with omnis VCS once to create the tables (now lowercase)
  • log off VCS in Omnis
  • delete all records in all tables (do not delete the tables!)
  • resore the dump

Now VCS should work as expected.

Von „http://wiki.mhcsoftware.de/Casesensitive_tablenames_with_MySQL_on_Linux“
Persönliche Werkzeuge
Navigation