KB Article #178036

Migration of File Tracking entries after upgrade to ST 5.3.3 for MySQL database

Due to a structural change of database tables related to File Tracking, the data related to transfers, made before upgrade, should be migrated to the new tables created on upgrade in order to be visible in SecureTransport 5.3.3 File Tracking. If the migration is skipped all the details related to transfers made before upgrade will NOT be visible on the File Tracking page.

If migration is NOT needed, skip the migration instructions and go directly section Dropping the old tables.

For instructions regarding File Tracking migration on external DB, refer to the following articles:

Prerequisites

IMPORTANT NOTE: Make a backup of your database before proceeding with the migration.

Make sure that all SecureTransport services, except for the database service, are stopped.

1. Execute the following command to stop all services:

<FILEDRIVEHOME>/bin/stop_all

2. Start the database service only:

<FILEDRIVEHOME>/bin/start_db

Migrating the File Tracking records

1. Copy the migration script file attached (mysql-migration.sql)and save it in the <FILEDRIVEHOME> folder.

NOTE: For ST installations on IBM AIX, due to the older version of MySQL supported (5.0.72), another migration script should be used – it is attached as mysql-migration-mysql-5.0_AIX.sql

2. Navigate to <FILEDRIVEHOME> and execute the below command, replacing DBUSERPASS with the database password (default is tumbleweed) and DBNAME with st:

Linux/Unix:

./mysql/bin/mysql --defaults-file=<FILEDRIVEHOME>/conf/mysql.conf –pDBUSERPASS DBNAME < mysql-migration.sql

Windows:

.\mysql\bin\mysql --defaults-file=<FILEDRIVEHOME>\conf\mysql.conf –pDBUSERPASS DBNAME < mysql-migration.sql

After the migration is successfully completed, the old tables should be dropped using the instructions in the next section.

Dropping the old tables

As the old tables won’t be used after the upgrade, they should be dropped using the attached mysql-migration_drop.sql script.

1.Save the mysql-migration_drop.sql script in the <FILEDRIVEHOME> directory

2. Execute the below command, replacing DBUSERPASS with the database password (default is tumbleweed) and DBNAME with st: