Restarting MySQL from CRON

Dan Nelson dnelson at allantgroup.com
Sat Sep 10 09:27:16 PDT 2005


In the last episode (Sep 10), Gerard Seibert said:
> From time to time, I have found that MySQL has ceased to run. I have
> a mailing program that requires that MySQL be running in order for it
> to operate.
> 
> Since I cannot seem to track down why it occasionally stops
> functioning, and since the program that depends on it is started via
> CRON, would it be advisable to put an entry into the CRON that would
> restart MYSQL prior to the other program running.
> 
> I was thinking of using this:
> 
> 0  0  *  *  * /usr/local/etc/rc.d/mysql-server.sh restart
> 
> Would that work, or is there a better way?

"start" is better than "restart", since that won't cause an existing
mysqld to exit.  But the startup script runs a script called
mysqld_safe, which automatically restarts mysqld if it crashes anyway. 
You might want to check your mysql .err log; maybe someone with the
SHUTDOWN privilege is doing a clean shutdown.

-- 
	Dan Nelson
	dnelson at allantgroup.com


More information about the freebsd-questions mailing list