Re: mysql db's hosed? Help needed badly

> I'm perfectly willing to do the retraining (it was the
falling behind
> that got me in this trouble to begin with).  How
exactly do I drop those
> tables as there's nothing useful in the logs, just
complaints about the
> dirty shutdown.  I just need to get this guy back up. 
 
Thanks.

First, make sure that nothing else is using the server (by
telling your 
services not to use it, moving the socket or any other way
to prevent 
users/services to use it) as that might make it harder for
you to issue 
your commands.

Then issue to following command:

mysql> DROP TABLE bayes_expire, bayes_global_vars,
bayes_seen, 
bayes_token, bayes_vars;

If this doesn't work (aka your mysql server crash) you have
a problem.

Then you have to recreate them, I've added the sql script as
an 
attachment to keep the mail a bit cleaner.

For process-quarantine.pl/spamassassin to properly work,
insert the 
following:

mysql> INSERT INTO bayes_global_vars(variable,value)
VALUES('VERSION','3');

This is based on personal experience, and might not be the
most 
efficient way, or the official way. Someone else on the list
may have a 
better way to do it 


-- 
Erik Weber

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users