[Spambayes] SpamBayes proxy database corruption

[Skip Montanaro]

    Ian> I am using dbm storage option (I wish there was a
    Ian> SpamBayes-MySQL-HowTo out there!) 

Hmmm...  The MySQL storage option is really only experimental.  As far as I
know nobody has really used it since I wrote it (not even me).  Still, if
you're willing to experiment, let me see if I can reconstruct how to use it.
(It's been awhile.)

In your options file set persistent_use_database to "mysql".  Set the
persistent_storage_file to a data source name like

    "host=localhost user=someuser pass=somepass dbname=foo"

The default is

    "host=localhost user=root pass= dbname=spambayes"

If it doesn't already exist, a table matching this definition will be
created:

    create table bayes (
        word varchar(255) not null default ''
        nspam integer not null default 0,
        nham integer not null default 0,
        primary key(word)
    );

That's based upon an examination of the source code.  Let me know if it
doesn't work and I'll dig into things a bit deeper.

Skip