Upgrading database software

If you have a prior Speech Suite installation with a Management Station database, and you intend to update the database software, the best procedure is to remove Speech Suite, update the database, and then install Speech Suite. (When you uninstall Speech Suite, the data in the database remains intact, and the service property configuration files in the NUANCE_DATA_DIR location are preserved.)

Upgrading to MySQL 8.0 on Linux

Note: MySQL 8.0 is supported by Speech Suite 11.0.4 and above

1. Backup the database and Management Station hosts. (They might be on the same host.)
2. Uninstall Speech Suite on the Management Station host.

3. On the database host, modify the MySQL configuration file. See Update the MySQL configuration.

4. Proceed with MySQL upgrade. See Upgrade MySQL .

5. Update the Connector/C to version 8.0 (if needed) on all hosts where Speech Suite speech components are installed. See Install the MySQL Connector/C for details.

6. Install Speech Suite.

Upgrading to MySQL 8.0 on Windows

1. Backup the database and Management Station hosts. (They might be on the same host.)
2. Uninstall Speech Suite on the Management Station host.

3. On the database host, modify the MySQL configuration file. See Update the MySQL configuration.

4. Proceed with MySQL upgrade. See Upgrade MySQL .

5. Update the Connector/C to version 8.0 (if needed) on all hosts where Speech Suite speech components are installed. See Install the MySQL Connector/C for details.

6. Install Speech Suite.

When updating the Connector/C, you can use the Windows MySQL Installer with a custom setup that only includes the Connector/ODBC product. For example:

Update the MySQL configuration

You must update the MySQL configuration before upgrading to MySQL 8.

On Linux, edit the /etc/my.cnf configuration file as described below.

Edit the /etc/my.cnf configuration file:

On Windows, edit the C:\ProgramData\MySQL\my.ini configuration file. (Your path might be different. For example, C:\Program Files\MySQL\)

Edit the C:\ProgramData\MySQL\my.ini configuration file. (Your path might be different. For example, C:\Program Files\MySQL\)

Note: Before editing the configuration file, you'll need to open the existing MySQL Server 5.7 folder and copy the my.ini file and Data folder to a newly created MySQL Server 8.0 folder.

Make these changes to the configuration file:

1. Remove NO_AUTO_CREATE_USER from sql-mode.

2. Ensure the file contains local-infile=1.

3. Remove query_cache_size from the file.
4. Ensure the mySQL installation does not include ONLY_FULL_GROUP_BY in the sql_mode setting:
   1. Display the setting with this command:

      mysql> select @@GLOBAL.sql_mode;

      Example output:

      ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

   2. If ONLY_FULL_GROUP_BY appears in the output, remove it. A simple way to do this is to add a new sql_mode setting in your mysql configuration: copy the output text (except for ONLY_FULL_GROUP_BY), add it to a MySQL system variable "sql-mode" in the mysql configuration, and save the changes.
   3. Restart MySQL and confirm the change by repeating the select @@GLOBAL.sql_mode; command.

5. Ensure that datadir has the path to the new data directory.

   For example on Windows: datadir="C:/ProgramData/MySQL/MySQL Server 8.0/Data"

6. Ensure that secure-file-priv has the path to the new data directory.

   For example on Windows: secure-file-priv="C:/ProgramData/MySQL/MySQL Server 8.0/Uploads"

Upgrade MySQL

Use the upgrade instructions below are examples. If you have questions, use the MySQL instructions for complete details.

Note: You must prepare the database configuration before performing the upgrade. See Update the MySQL configuration.