[Maia-users] bayes issues

[Robert LeBlanc]

Matt Goodhue wrote:

> I would like to dump all my bayes data and start over.  It is in a MySQL
> Database called sa_bayes, what would be the best way to do this?

Use the MySQL console to connect to your sa_bayes database, and then
delete all of the rows in the Bayes-related tables:

DELETE FROM bayes_token;
DELETE FROM bayes_seen;
DELETE FROM bayes_vars;
DELETE FROM bayes_expire;

It would be more practical, I think, to keep your Bayes within the Maia
database, along with the rest of the Maia-related tables.  This would
put it in a position to be managed by other Maia-related tools, like the
forthcoming maiadbtool script.


> I also found out my process-quarantine.pl process has not been running
> like I thought it was.  So needless to say I have over a month of spam
> queued up to reanalyze.  Is there any way to clear this stuff out so I
> can start over?

Sure.  Go to "Admin->System Configuration" and reduce the expiry periods
for spam and non-spam to something small (e.g. 1 or 2 days), and then
run the expire-quarantine-cache script, with the --confirmed-spam and
--confirmed-nonspam flags added in.  This will delete any items older
than your expiry period.  Be sure to set your expiry periods back to
whatever day-to-day values you use, afterward.

-- 
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: OpenPGP digital signature
Url : http://www.renaissoft.com/pipermail/maia-users/attachments/20060921/760cca3f/attachment.bin