Overview

This article outlines steps to upgrade the database manually.

Solution

The ListManager installer will automatically upgrade the database with any necessary schema changes when upgrading an existing installation. However, when migrating a database to a new installation, it may be necessary to manually trigger the database upgrade function if the new installation is a higher version. ListManager will not run if the database tables are not of the same version as the ListManager application files.

Upgrading the ListManager database

1. Shut down the ListManager application
2. Open the lmcfg.txt file from the installation directory
   
   • At the bottom of this file, locate the database connection parameters used by ListManager.  Verify that this is the correct database that should be upgraded.
     Example,
     

     $node_name="LYRIS";
     $sql_type="MSSQL";
     $sql_server="LYRIS\SQLEXPRESS";
     $sql_user="sa";
     $sql_password="LYRISPWD";
     $sql_database="lm101";
     $sql_pool="25";

3. Open a command prompt and navigate to the install directory
4. Run the following command:
   • lm dbupgrade
5. After this completes, start the ListManager services as normal

Considerations

• Back up the database before performing this function.
• Upgrades can not be reversed.