From owner-freebsd-questions@FreeBSD.ORG Sat Sep 10 18:05:36 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7041B16A41F for ; Sat, 10 Sep 2005 18:05:36 +0000 (GMT) (envelope-from gerard-seibert@suscom.net) Received: from smtp2.suscom.net (smtp2.suscom.net [64.78.83.231]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9D31F43D53 for ; Sat, 10 Sep 2005 18:05:33 +0000 (GMT) (envelope-from gerard-seibert@suscom.net) Received: from localhost (smtp2.suscom.net [127.0.0.1]) by smtp2.suscom.net (Postfix) with ESMTP id E2AED1CDD7E; Sat, 10 Sep 2005 13:55:15 -0400 (EDT) Received: from smtp2.suscom.net ([127.0.0.1]) by localhost (smtp2 [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 16867-08; Sat, 10 Sep 2005 13:55:12 -0400 (EDT) Received: from [192.168.0.2] (ip148.217.susc.suscom.net [216.45.217.148]) by smtp2.suscom.net (Postfix) with SMTP id 972381CDCF6; Sat, 10 Sep 2005 13:55:12 -0400 (EDT) Date: Sat, 10 Sep 2005 14:05:32 -0400 From: Gerard Seibert To: Dan Nelson Sender: Gerard@smtp2.suscom.net, Seibert@smtp2.suscom.net In-Reply-To: <20050910162702.GJ84582@dan.emsphone.com> References: <20050910162702.GJ84582@dan.emsphone.com> Message-Id: <20050910140047.81C2.GERARD-SEIBERT@suscom.net> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" X-Mailer: Becky! ver. 2.22.01 [en] Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at suscom.net Cc: freebsd-questions Subject: Re[2]: Restarting MySQL from CRON X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: gerard-seibert@suscom.net List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 10 Sep 2005 18:05:36 -0000 =1EOn Saturday, September 10, 2005 12:27:02 PM Dan Nelson wrote: > 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. > >=20 > > 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. > >=20 > > I was thinking of using this: > >=20 > > 0 0 * * * /usr/local/etc/rc.d/mysql-server.sh restart > >=20 > > Would that work, or is there a better way? >=20 > "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.=20 > You might want to check your mysql .err log; maybe someone with the > SHUTDOWN privilege is doing a clean shutdown. >=20 > --=20 > Dan Nelson > dnelson@allantgroup.com ********** Reply Separator ********** Saturday, September 10, 2005 2:00:47 PM It definitely does not restart automatically. In addition, I am the only user with root access. I doubt that anyone is shutting it down, even by mistake. Where do I find this mysql error file? I cannot seem to locate it. Thanks for your assistance.