>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.

My observation is that when you shut down the server process, the
socket goes away, and when you start it up again, it comes back.
I'm running FreeBSD 6 now, but I've been running FreeBSD and MySQL
for a long time and this hasn't changed recently. Now, if the
server fails to start for some reason, like passing it bogus
command-line options which I've done a few times, it will quit and
not create the socket.

Check permissions on /tmp and /var/db/mysql to make sure the server
won't have problems trying to create the socket or log files.
Also make sure there's a decent amount of disk space.

>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

You need to be really careful about permissions and ownership here,
as you've noted.

>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.)