If this document does not correspond to your current software version, you can go to Download Center to find other available document versions.

QNAP

QuTS hero h5.2.x

Download (PDF)

Migrating a MariaDB 5 database to MariaDB 10

This feature is only available in the MariaDB 10 app.

  1. Log on to QuTS hero as administrator.
  2. Install the MariaDB 10 app.
    Note:

    For details, see Installing an app from App Center.

  3. Open the MariaDB 10 app.

    The MariaDB Setup Wizard window opens.

    Note:

    The MariaDB setup wizard only appears during app initialization. To configure more advanced database features and settings, edit the php.ini maintenance file. For details, see Modifying the PHP configuration.

  4. Click Start.

    The Database Actions screen appears.

  5. Select Migrate a MariaDB 5 to a MariaDB 10 database.
  6. Click Next.

    The Default Instance Properties screen appears.

  7. Optional: Configure TCP/IP networking.
    1. Select Enable TCP/IP networking.
      Note:

      This option is enabled by default.

    2. Specify the TCP/IP networking port.
      Note:

      The default port is 3307.

  8. Click Apply.

    QuTS hero migrates the existing MariaDB 5 database to MariaDB 10. The Finish screen appears.

    Note:

    The data migration may take a few minutes to complete.

  9. Click Finish.

    QuTS hero enables the MariaDB server.