Solution to table failure in Ubuntu Dotcms Installation

Today, Xiao Qiu said that there was a problem with running Dotcms In Ubuntu. I also tried it and found that there was always a problem that the table Dotcms could not be found. the group _ problem exists in my database. However, I found that this table does not exist in MySQL. I thought it may be MySQL Case sensitivity, after reading the Dotcms documentation, I did say I want to change the MySQL configuration. add lower_case_table_names = 1 & nb to the cnf configuration.

Today, Xiao Qiu said that there was a problem with running Dotcms In Ubuntu. I also tried it and found that there was always a problem that the table Dotcms could not be found. the group _ problem exists in my database. However, I found that this table does not exist in MySQL. I thought it may be MySQL Case sensitivity, after reading the Dotcms documentation, I did say I want to change the MySQL configuration. add lower_case_table_names = 1 in the cnf configuration and then re-create the table.

I checked the MySQL Case sensitivity issue and looked at the following:

In MySQL, database and table pairs are stored in directories and files under those directories. Therefore, the sensitivity of the operating system determines the case sensitivity of the database and table names. This means that the database and table names are case-insensitive in Windows and are case-sensitive in most types of Unix systems.

It is strange that the column name and column alias are case-insensitive in all cases, while the table alias is case-sensitive.

To avoid this problem, you 'd better define all the database naming rules in combination with lowercase letters and underscores instead of any uppercase letters.

Alternatively, you can force the-O lower_case_table_names = 1 parameter to start MySQLd (if -- defaults-file =... \ my. if the cnf parameter is used to read the specified configuration file and start MySQLd, you need to add a line lower_case_table_names = 1 in the [MySQLd] section of the configuration file ). In this way, MySQL automatically converts all table names to lowercase characters when creating and searching (this option is 1 by default in Windows and 0 in Unix. From MySQL 4.0.2, this option also applies to the database name ).

When you change this option, you must first convert the old table name to lowercase letters before starting MySQLd.

In other words, if you want to retain the case-sensitive characters when creating a table in the database, set this parameter to 0: lower_case_table_names = 1. Otherwise, you will find that the same sqldump script imports different results in different operating systems (all uppercase characters in Windows are changed to lowercase letters)