Knowledgebase:
Converting a Workflow or Webmail internal HSQL Database to MySQL
Posted by Aly Essa, Last modified by Aly Essa on 08 June 2016 06:29 PM

Overview

The FileCatalyst Web Suite is shipped with an internal database (HSQL DB) which should only be used for testing purposes. The HSQL Database is a lightweight tool which does not offer any backup or recovery options. Before any FileCatalyst Web Deployment is moved into production it is imperative that an external database is used. We recommend the MySQL Community Server.

 

Environment

FileCatalyst Workflow v4.7 and later.

FileCatalyst Webmail v4.7 and later.

 

Resolution

Note: Before completing these steps you should back up your Workflow Configuration or FCWeb Configuration Folder. The location of your Configuration folder can be found in the About FileCatalyst screen.

You will also want to ensure users are not logged into the site during this process. To ensure this you can block the access ports (80 or 443 for SSL). The following Resolution instructions are based on a Windows Installation.

  1. Download and install MySQL Community Server from http://dev.mysql.com/downloads/mysql/
    1. When the MySQL installer executes, select the Full radial. This option will install the Community Server as well as the Workbench tool. The Workbench tool allows easy migrations, backups, and repairs of MySQL tables.
    2. Fill out the necessary information, such as the installation paths. Keep track of the password you enter for the MySQL Root Password field as it will be needed in the next steps.

  2. Once installed, browse to your FileCatalyst Workflow/Webmail site and log in as Super Admin.
  3. Go to Modify Configuration at the top of the menu bar.
  4. Click on Edit Database Settings link under the Advanced Settings section.
  5. Select the MySQL radial to enable the Database Settings fields.
  6. Do not adjust the Driver and Path fields.
  7. Enter a Database Name. You can name it workflow or fcweb. Do not use a database name that already exists.
  8. The username should be root and the password should be what you entered during the MySQL Installation in step 1b.
  9. Click the button below to Convert Existing Data once. Depending on the size of your database this may take some time so wait for it to finish. Please be patient to prevent any corruption during the conversion.