Creating the project results database by using MySQL

You can create project results databases by using MySQL.

Before you begin

For information about the supported versions of the database, see the Supported Software > Database section in the download document https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0069175.

Procedure

  1. Logged in as user root, create and use a new database.
    Note: If you need to store Unicode results, enter the following command to create the database:
    CREATE DATABASE db_name CHARACTER SET = utf8 COLLATE = utf8_unicode_ci;
    Note: There might be limitations as described here: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-utf8.html
  2. If you use Linux, or if you use UFS volumes on Mac OS X, edit the MySQL configuration file (my.cnf) to store table names as lowercase and to ignore case in comparisons. The location of this file can vary. In the my.cnf file, set the MySQL system variable lower_case_table_names to 1. This change is not necessary on Windows, where file names are not case-sensitive.
  3. To ensure that MySQL uses the database you created in Step 2, run the following command:
    USE database_name;
  4. Run the ghtester_mysql.sql script against the new database by entering a command in the following format:
    SOURCE installation_directory/scripts/ghtester_mysql.sql;
    Note: If you are using a command prompt on a Microsoft Windows system, the path separator must be reversed. For example:
    SOURCE C:/Program Files/HCL/HCLProducts/API/scripts/ghtester_mysql.sql;
Feedback