replacing missing mysql.sock (FreeBSD OS)
Don't you hate it when you have a missing sock?
I'm hoping there's someone (anyone!) who knows FreeBSD who can advise
me how to recreate the MySql socket file in its default location (in
my case, in /tmp/mysql.sock). Seems my /var partition got over-full
last night and evidently brought down the server. I guess that was the
cause; I can't see any other.
Since last night, I haven't been able to restart MySql. This effects
of my sites, since most of my content now runs on Drupal, which
requires MySql. One of the things that I did today was move MySql data
files to my /usr partition, where there's more room, with a sym link
to its default location at /var/db/mysql; careful to chown the
directory and files to the user mysql. I also tried deinstalling and
then reinstalling MySql from ports, hoping that would resurrect the
socket, but no go. I've googled and scoured the mysql.com, to no
avail. If there is an answer out there (and there undoubtedly is, I
haven't been able to find it.)
Any suggestions would be sincerely appreciated. I know there are a lot
of a number of subscribers here who are more expert than me with
MySql.
I'd really like to get this thing back ASAP, if possible, not just for
my own site, but also for the benefit of the people and organizations
who relying on me as a host.
Many thanks.
Tom
P.S. For the record, I'm running a mixture of Drupal sites; some
v4.7.x and others v5.x. OS is FreeBSD 6.1 on Apache 1.3.24, PHP 5.1.2
mod_perl/1.29, MySql 5.0.18, with Gallery 2.1, TNG 6.1, and PmWiki
2.0.13.
|