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