Database Operations

ListManager has a number of command line options for database actions. To use them, open a command prompt, and change to the directory where you have installed ListManager. Then, run

lm command

or

./lm command

if you're using Unix.

configclear

Clears the machine name from the ListManager Config_ table. ListManager should not be running when this command is run.

configcopy

Copies an existing ListManager configuration to the machine name specified. Use this option if you are adding a new node to a ListManager cluster. Note: Lyris ListManager configuration are stored by machine name: to obtain a list of existing configuration names, run the command "lm configlist". You only need to specify an old-config-name if you have several pre-existing configurations in your Lyris ListManager database:

lm configcopy oldname

ListManager should not be running when this command is run.

configlist

Retreives a list of machine names configured in your Config_ table. By default, there will be only one configuration.

configmove

Use this option if you have renamed the Lyris ListManager machine, or moved your Lyris ListManager installation to a new machine. By default, you should only have one machine name configured in Lyris ListManager, and by running this command, this one configuration will be changed to the new machine name.

Note: Lyris ListManager configuration are stored by machine name: to obtain a list of existing configuration names, run the command "lm configlist".

You only need to specify an old-config-name if you have several pre-existing configurations in your Lyris ListManager database:

lm configmove oldname

copy2foxpro

Creates FoxPro tables and converts ListManager 5.0 SQL database files to Microsoft FoxPro format. ListManager should not be running when this command is run.

copy2sql

Converts ListManager 3.x and 4.x database files to SQL format. Normally, the Setup program takes care of running this program for you when upgrading from earlier non-SQL versions. After running copy2sql, you'll need to manually update your serial code, either by running lm serial yourcode or by running ListManager and entering the code in Server Config. See Setting Server Options for more information about the serial command. ListManager should not be running when this command is run.

dbcreate
Create all database tables used by ListManager. Any existing ListManager tables in the database will be deleted and recreated.

If you specify a password on the command line, this will be used to create a default administrator account with the name "admin". If you do not specify a password the password for the admin account will be "lyris".

For example, to create the databases with an admin password of "blue", you would type:

lm dbcreate blue

Please note that this will completely erase any data you have in the ListManager tables in your database and start you anew. If you are unsure about this command, back up your database first.

ListManager must not be running when this command is run.

After running dbcreate, you'll need to tell ListManager what your activation code and DNS server TCP/IP address are. You can either insert that data into the Config_ table directly, or use a command to enter this information. See Setting Server Options for more information about the activate and dns commands.

dbinmailcreate

Recreate the incoming mail database table, clearing the table that already exists.

This option is useful if you want to quickly erase all email in the incoming mail database, perhaps because you sent a lot of email to ListManager that you now realize you do not want it to process.

ListManager should not be running when this command is run.

dboutmailcreate

Recreate the outgoing mail database table, clearing the table that already exists.

This option is useful if you want to quickly erase all email in the outgoing mail database, perhaps because you told ListManager to send a lot of email you now realize you do not want it to send.

ListManager should not be running when this command is run.

dblogcreate

Recreate the ListManager log database table, clearing out all log entries that are currently there.

This option is useful if you want to completely clear all the log entries in ListManager, in a very rapid manner. For example, if you have no need for the existing log entries, this will remove them all.

ListManager should not be running when this command is run.

dbupgrade
Converts the ListManager database files to the most current format. You need to run this command when upgrading to a new version of ListManager. Normally, the Setup program takes care of running this for you.

ListManager must not be running when this command is run.