quick solution?

[Matthew Seaman]

Kris Anderson wrote:
> --- jekillen <jekillen at prodigy.net> wrote:
> 
>> Hi all;
>> I had a blackout occur and the server I'm running
>> overran the ups 
>> support before I could get to it to shut it down
>> cleanly.
>> It has been restarted but now my MySQL server
>> complains that it can't 
>> connect through mysql.sock. Being impatient
>> and lazy, I'm wondering if there is a quick
>> solution. Or should I grit 
>> my teeth and RTFM?
>> I'm running FreeBSD v6.0 (as to why I'm querying
>> this list).
>> Is there a utility for a general inspection of the
>> system and software?
>> Thanks for any helpful replies.
>> JK
> RTFM, but...
> Occasionally I get odd things happening, things not
> starting up even though rc.conf has the right
> information. Try starting by hand using the script in
> /usr/local/etc/rc.d
> If it doesn't start that way, then run the command
> that actually starts mysql and see if it complains
> about something missing.

Before doing anything else, first read the MySQL error log --
usually in /var/db/mysql.  I suspect that you need to run a repair
job on some of your databases -- mysqlcheck is your friend.

Once you've done that, mysql should come up smoothly.

	Cheers,

	Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.                       7 Priory Courtyard
                                                      Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey         Ramsgate
                                                      Kent, CT11 9PW

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060415/f4bdea26/signature.pgp