Moving ListManager with an External Database

If you are using an external database (MS SQL, Oracle) and you'd like to move your ListManager installation, follow these steps.

1. Shut down your old ListManager installation.

2. Install ListManager on the new machine. Provide the information requested to connect to your SQL database server, but do NOT have ListManager create the tables for you--this will delete your database!

Alternatively, you may create a database or user just for the installation, and change which database ListManager uses by editing lmcfg.txt with a plain text editor. See Connecting to Your Database with lmcfg.txt for more information about editing this file.

3. Shut down ListManager if you started it after the installation.

4. To allow your database to be used with your new ListManager machine, you'll need to change the machine name in the Config_ table. To do so, run the following command on the command line:

lm configmove

3. Update your activation code by opening a command prompt and running the getactivation command. Change to the lm directory and run the following commands:

lm clearactivation

lm getactivation

4. Start ListManager on the new machine.

5. Go to Utilities: Administration: Sites, and edit any sites you have, so that the Internet Host Name field for each site is the name of your new ListManager machine.

  You're done!