Re: mysql db's hosed? Help needed badly

Erik:

Beautiful!  Thank you so much.  It was rather interesting to
be entering
the sql commands in one window and then seeing the
utilization plummet in
another.

-- 
Rick Zeman
Manager of Information Technology
Melwood Horticultural Training Center
301.599.4574 - HelpDesk
301.599.4560 - MyDesk
http://www.melwood.org

>>> Erik Weber <twiztargmail.com> 10/3/2007
10:30:04 AM >>>
> 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