Re: InnoDB problem

Wojtek Bogusz wrote:
> hi Erik. thank you for your email.
>
> it also look to me like bayes table problems. but i
just wanted to 
> make sure, that i understand you well  so i
should connect to mysql 
> and DELETE FROM bayes*; and than how do i recreate
them? how do i 
> teach it "the basis" from quarantine? sorry i
am not very much 
> experienced :(
>
> i have binary log in /var/log/mysql/mysq-bin.* but i
cannot make sence 
> how would i use them in this situation. would they be
useful?
>
> is "sa-learn --backup" an mysql switch? would
it make sense to add it 
> to config somewhere?
(Including the list so others might benefit or come with
suggestions)

You could do a DELETE FROM, or a DROP TABLE and then
recreate it. We did 
the latter since the table was quite big and we feared that
it might 
just crash when trying to delete entries.
What you might want to do is rename the table and create a
new, that way 
you can look for a way to repair it and if successful rename
it back.
Not sure about the syntax, but it should be something like
"ALTER TABLE 
bayes_token RENAME TO bayes_token_orig"

sa-learn (invoked by/from process-quarantine.pl) is the
application used 
for teaching spamassassin (and thus the bayes database)
about spam/ham, 
--backup is the switch needed for making a dump.
You can su your amavisd-maia user and watch the output
(well, if your 
database worked..), it's way more human-friendly than your
mysqldump 
dumping it in raw/binary format.
We had large issues with importing our mysqldump and finally
gave up and 
recreated an empty one.

To devs: I'm note sure what the Wiki/INSTALL/README say
about this, but 
if it's not mentioned maybe it would be wise to mention that
backup of 
the bayes database should be done with sa-learn --backup?

Regarding importing from binary logs I'm not sure about the
right way to 
do it, maybe someone else on the list have any input
regarding that.
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Erik Weber wrote:

> To devs: I'm note sure what the Wiki/INSTALL/README say
about this, but 
> if it's not mentioned maybe it would be wise to mention
that backup of 
> the bayes database should be done with sa-learn
--backup?

Backing up the Bayes database isn't something I'd bother
with, frankly;
it regenerates very quickly, and with fresher spam and ham
samples,
which tend to make it more effective than a database that
has been
hoarding ancient tokens from months or years ago and
expiring them
slowly.  If you lose your Bayes database, it's nothing to
cry
over--start it fresh and within a few days it should regain
most of its
performance benefit.

- --
Robert LeBlanc <rjlrenaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGjB5aGmqOER2NHewRArKSAJ0SIMpMpmZyYNRT4gUiiJbQxq9spwCf
YfCr
IbELl2TOqB7qg3uP7kHBY4c=
=VcWe
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users