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?
--- 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]
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: 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: 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]