1. Home
  2. Tekla PowerFab
  3. Manage Tekla PowerFab
  4. Update MySQL version for Tekla PowerFab

Update MySQL version for Tekla PowerFab

Tekla PowerFab Tekla PowerFab GO
Modified: 16 Sep 2025
2025i
Tekla PowerFab Tekla PowerFab GO

Update MySQL version for Tekla PowerFab

Tekla PowerFab officially supports MySQL up to version 8.0.35. In order to upgrade the MySQL version from 5.0.90, you must be running Tekla PowerFab 2020 SP2 or later.

Supported MySQL versions

Tekla PowerFab/EPM version MySQL 8.0.351 MySQL 5.7.41 MySQL 5.7.29 MySQL 5.6.36 MySQL 5.0.90
2022–Current release ✓2 ✓ ✓ ✓ ✓
2021i - ✓ ✓ ✓ ✓
2021 - - ✓ ✓ ✓
2020i - - ✓ ✓ ✓
2020 - - - ✓ ✓

1The use of MySQL 8 is restricted to 64-bit computers. 32-bit builds of MySQL 8 are not available.

2Tekla PowerFab 2023i SP3, Tekla PowerFab 2023 SP8, Tekla EPM 2022i SP9, Tekla EPM 2022 SP10 or greater is required for MySQL 8 support.

We recommend that you update to the latest Tekla PowerFab version available before upgrading the MySQL version. We also recommend to repair program errors and compress the Tekla PowerFab database before backing up the database. For instructions, see:

Note: All steps must be performed from the server where MySQL is installed. When updating the MySQL version, all users must be signed out of Tekla PowerFab and MySQL.

Clean MySQL update

This update comprises uninstalling the old version and installing a new version of MySQL.

Note: Before you start:

When updating the MySQL version, ensure that all users have logged out of Tekla PowerFab and MySQL before saving a backup copy of the Tekla PowerFab database until the Tekla PowerFab database has been restored on the new version.

Before performing the steps below, see the following instructions:

  1. Locate the installer for the MySQL version you want to install in either of the following ways:
    • In MySQL Installer for Tekla PowerFab on the Tekla Warehouse.

      Only MySQL versions maintained by MySQL are provided on Tekla Warehouse.

    • In the default install location of the Default Directories for backup (C:\Users\Public\Documents\Tekla\Backup), you should find mysql_setup_<version>.exe.

      If you do not have the installer version you want, contact support to provide it.

      For further information, see:

  2. On the server, open Tekla PowerFab as an administrator.
  3. (Optional, recommended) Repair program errors.
  4. (Optional, recommended) Compress the Tekla PowerFab database.
  5. Save a backup copy of the Tekla PowerFab database.

    Do not save this to the MySQL install location.

  6. Close Tekla PowerFab.
  7. Open the Windows Services application, locate the MySQL service for the Tekla PowerFab database and stop the service.

    Depending on what version you started with, the service name may be MySQL_TeklaPowerFab, MySQL_TeklaEPM, or MySQL_Fabsuite. The service name can be customized with the MySQL Service Manager, so it can be anything.

  8. (Optional) To uninstall the current version of MySQL, run uninstall.exe from the MySQL install location.

    Typically, the location is C:\mysql\ but it could have been customized.

    Note: Before uninstalling the current version of MySQL, ensure that there are no other programs or services that also use it. If there are, you must install a second MySQL for the new version.
  9. To install MySQL, run mysql_setup_<version>.exe located in the default install location of the Default Directories for backup.

    See Step 2.

    If you are installing a second instance of the MySQL program, you must specify a new default directory, C:\MySQL8, for example. Running the mysql_setup_8.exe provided by Trimble creates a new MySQL_Tekla PowerFab service on port 3306.

  10. Open Tekla PowerFab as an administrator
  11. Restore the Tekla PowerFab database.

    Use the database backup created in Step 6.

  12. Recreate the Tekla PowerFab Remote Server service.
    1. Open the Tekla PowerFab Remote Monitor.

      This is normally located in the Tekla PowerFab install directory and the application name is Tekla.PowerFab.Remote.Monitor.exe.

      See also Tekla PowerFab Remote Monitor.

    2. To remove the existing service, select it in the dropdown menu and click the minus (-) button.
    3. To create a new service, click the plus (+) button.

      The service dependency should be MySQL_Tekla PowerFab.

  13. Set up and start Tekla PowerFab Remote Server.

After completing all these steps, users can log back into Tekla PowerFab Office and Tekla PowerFab Go.

Failed upgrade

If the upgrade fails, a message dialog appears with the text Update Failed.

  1. Click OK.

    Another message appears indicating that the upgrade is rolled back to its previous state.

  2. To proceed with the rollback, click OK.

    Every step that has been taken up to this point is reversed. This leaves MySQL in the same state as it was before the upgrade, and the Upgrade Settings dialog re-appears.

    You can then adjust any settings and try the upgrade again or contact technical support for further assistance.

Was this helpful?
Previous
Next