Lyris User's Guide
[previous] [next] [contents]
Database Operations
Table of Contents
Introduction
Lyris Email Commands
Web Interface for Users
Server Administrator
Site Administrator
List Administrator
Other Topics
Security Considerations
Security Issues Relating to Members
Lyris Mail Merge
The Lyris command line
Starting Lyris
Database Operations
Setting Server Options
Windows Services
Unix Daemon Option
Modifying lyris.plc
Add-On Packages
Installing and Upgrading
Appendix
Frequently Asked Questions

Database Operations

Lyris uses a number of database files for storing all its information. These files are stored in the ~lyris\db directory. The command line options operate on the database files:

dbcreate
Create all database tables used by Lyris. Any existing tables in the "db" directory 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:

    lyris dbcreate blue

Please note that this will completely erase any data you have in ~lyris\db and start you anew. If you are unsure about this command, back up your ~lyris\db directory first.

Lyris must not be running when this command is run.

dbinmailcreate

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

This option is useful if a catastrophic disk error has occurred, and your incoming mail database is corrupted, and you thus want to rebuild it from scratch.

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

Lyris must 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 a catastrophic disk error has occurred, and your outgoing mail database is corrupted, and you thus want to rebuild it from scratch.

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

Lyris must not be running when this command is run.

dblogcreate

Recreate the Lyris 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 Lyris, in a very rapid manner. For example, if you have no need for the existing log entries, this will remove them all.

Lyris must not be running when this command is run.

dbfastpack
Removes completed mail from the incoming and outgoing mail databases and compresses them.

Lyris must not be running when this command is run.

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

This dbupgrade option also reindexed the database, and removes any wasted space. The dbupgrade option is the best choice for cleaning up and tuning the existing Lyris database files.

Lyris must not be running when this command is run.

Other pages which link to this page:
  • Server Admin Log
  • The Lyris command line
  • New in 3.0 beta 5 (v2.548)
  • Page 409 of 556