This shows you the differences between two versions of the page.
Last revisionBoth sides next revision | |||
reference:database_files_used_in_vpop3_2.x [2010/03/04 09:36] – created paul | reference:database_files_used_in_vpop3_2.x [2010/03/04 09:41] – paul | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Database files used in VPOP3 2.x====== | ======Database files used in VPOP3 2.x====== | ||
+ | VPOP3 2.x usually uses SQLite 2.8.3 as its database engine. This stores databases in discrete *.db files in the VPOP3\_database directory on the server PC. We do not recommend that you access these databases directly unless you know what you are doing, and we strongly discourage the alteration of data in the databases directly unless technical support request you to. | ||
* **logdb.db** - this contains historical logging information for reports. It can be configured/ | * **logdb.db** - this contains historical logging information for reports. It can be configured/ | ||
* **spamfilter.db** - this contains statistical information for the Bayesian filter section of the VPOP3 spam filter | * **spamfilter.db** - this contains statistical information for the Bayesian filter section of the VPOP3 spam filter | ||
* **msgids.db** - this contains summary information on the last few days' worth of emails, for duplicate detection | * **msgids.db** - this contains summary information on the last few days' worth of emails, for duplicate detection | ||
- | * **archive*.db** - this contains index information for the message archive facility in VPOP3 | + | * **archive*.db** - this contains index information for the message archive facility in VPOP3. In older versions of VPOP3, there is a single **archive.db** file. In later versions there are **archive< |
* **user_*.db** - these contain mailbox index information for the individual users | * **user_*.db** - these contain mailbox index information for the individual users | ||
* **quarantine.db** - this contains information about messages which ahave been quarantined by the VPOP3 content/ | * **quarantine.db** - this contains information about messages which ahave been quarantined by the VPOP3 content/ | ||
- | Certain | + | Whilst VPOP3 is stopped, certain |
Note that we do not recommend deleting any of the databases in normal operation (otherwise VPOP3 would delete them for you, or they simply wouldn' | Note that we do not recommend deleting any of the databases in normal operation (otherwise VPOP3 would delete them for you, or they simply wouldn' | ||
Line 14: | Line 15: | ||
* **msgids.db** - this can be deleted. You may receive a few duplicate messages (depending on how your Internet connection is configured), | * **msgids.db** - this can be deleted. You may receive a few duplicate messages (depending on how your Internet connection is configured), | ||
* **spamfilter.db** - this can be deleted, but the spamfilter will be less effective for a while. | * **spamfilter.db** - this can be deleted, but the spamfilter will be less effective for a while. | ||
- | * **archive.db** - this should not be deleted. If you delete | + | * **archive*.db** - these should not be deleted. If you delete |
* **user_*.db** - these should not be deleted. If they are deleted, you will not lose any messages, but you will lose any IMAP4/ | * **user_*.db** - these should not be deleted. If they are deleted, you will not lose any messages, but you will lose any IMAP4/ | ||
* **quarantine.db** - this should not be deleted. If you delete this file, VPOP3 will lose the facility to access or tidy up any messages which are in the VPOP3 quarantine. | * **quarantine.db** - this should not be deleted. If you delete this file, VPOP3 will lose the facility to access or tidy up any messages which are in the VPOP3 quarantine. |