On 2001-05-07 17:28:16, "Andrei Zmievski" <[EMAIL PROTECTED]> wrote:
> The MySQL server on the machine died. I've restarted it and it's now
> rebuilding the entire check-in history to make sure it's complete.
I know this isn't entirely relevant to PHP, but I thought it might
help...
I've found an interesting "feature" of mySQL and the "standard" cron jobs
found in most Linux distros.
If you are using a unix socket to connect to mySQL, that socket usually
lives in /tmp. Most distros periodically purge old files from /tmp, and
since the mysql.sock is not owned by root, it gets deleted and that causes
mayhem when trying to connect to mysql.
I've encountered (and been seriously bitten by) this problem on
Cobalt/RedHat, RedHat and SuSE distros. The solution is simply to prevent
that socket from being deleted either by changing ownership or tuning the
overnight cron job.
--Wez.
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
