Re: quick solution?
Kris Anderson wrote: > --- jekillen <[EMAIL PROTECTED]> 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 signature.asc Description: OpenPGP digital signature
Re: Quick solution: addendum; solved
--- jekillen <[EMAIL PROTECTED]> wrote: > Hi > I'm blushing over the quick solution to mysql > problem. > I used the wrong script name to start mysql. It was > a trivial > script I wrote because I didn't want to practice > typing every > time I started mysql. I use the wrong name mysql > start > instead of mysql-start; > Oddly, the shell didn't refuse to execute the script > with the > error script name command not found, it threw > these errors as if it was actually trying to execute > the script. > The server has started without complaint with the > correct > script name. > Sorry to waste your time. > JK > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "[EMAIL PROTECTED]" > LOL! No worries. We need a bit of humor from time to time. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Quick solution: addendum; solved
On Fri, 14 Apr 2006 21:22:47 -0700 jekillen <[EMAIL PROTECTED]> wrote: > Oddly, the shell didn't refuse to execute the script with the > error script name command not found, it threw :) glad to hear it works now. maybe you didn't see an error as 'mysql' is a valid command? (the MySQL SQL command interface) beto ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: quick solution addemdum
In the last episode (Apr 14), jekillen said: > In addition to the mysql, quick solution question: > the error is literally: > ERROR 2002 [HY000]: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (61) Looks like mysql has crashed. Restart it and it will recreate the socket file. If it refuses to start, look at the err file in /var/db/mysql . -- Dan Nelson [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: quick solution?
--- jekillen <[EMAIL PROTECTED]> 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. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"