This is a part MySQL and part linux question. When my server reboots which on occasion it needs to... the socket file for MySQL is purged (/tmp). I am looking for away to have the safe_mysqld fired up as part of the boot process. Does anyone have any ideas on this or where the files are I should edit?

Many thanks,

M.

find the file mysql.server and follow the instructions in it... I think it needs to go in your init.d folder.... (but that's off the top of my head... []/w3timages/icons/wink.gif[/])

Matt

I found it! Just need to spend some time reading the man file for it and I will be off to the races. Thanks Matt!

I set up my rc.local with a command:

csh -cf '/etc/mysqld &'

the file contains:

#!/bin/sh

cd /usr/local/mysql
bin/safe_mysqld

This works well for me, my system uses SysVInit scripts, but I didn't feel like writing a SysV script for mySQL. This setup spawns a new shell and runs mysqld in it, instead of executing mySQL in the current shell (thus making it unusable).