Hi,
since so many have problems i share my mysql shemas :=)
please note that i expire som data not default done in current spamassassin
Your schema did not work for me. I deleted the existing database and
recreated it, then created the tables using your schema. When starting
to restore, a number of errors including these are produced:
Use of uninitialized value in concatenation (.) or string at
/usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 139.
bayes: found bayes db version
Use of uninitialized value $db_ver in numeric ne (!=) at
/usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 141.
Use of uninitialized value $db_ver in concatenation (.) or string at
/usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
bayes: database version is different than we understand (3), aborting!
at /usr/share/perl5/Mail/SpamAssassin/BayesStore/SQL.pm line 142.
It appears I'm using the same version as your schema indicated, so I'm
not sure what the problem could be.
mysql Ver 14.14 Distrib 5.1.56, for redhat-linux-gnu (x86_64) using
readline 5.1
Thanks,
Dave
