From owner-freebsd-questions@FreeBSD.ORG Sat Sep 10 16:12:32 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 C46BC16A41F for ; Sat, 10 Sep 2005 16:12:32 +0000 (GMT) (envelope-from gerard-seibert@suscom.net) Received: from smtp5.suscom.net (smtp5.suscom.net [64.78.83.245]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6C45043D4C for ; Sat, 10 Sep 2005 16:12:32 +0000 (GMT) (envelope-from gerard-seibert@suscom.net) Received: from localhost (unknown [127.0.0.1]) by smtp5.suscom.net (Postfix) with ESMTP id 669C651025F for ; Sat, 10 Sep 2005 12:12:30 -0400 (EDT) Received: from smtp5.suscom.net ([127.0.0.1]) by localhost (smtp5 [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 10495-01-7 for ; Sat, 10 Sep 2005 12:12:23 -0400 (EDT) Received: from Gerard.seibercom.net (ip148.217.susc.suscom.net [216.45.217.148]) by smtp5.suscom.net (Postfix) with SMTP id 48434510237 for ; Sat, 10 Sep 2005 12:12:23 -0400 (EDT) Date: Sat, 10 Sep 2005 12:12:26 -0400 (Eastern Standard Time) From: Gerard Seibert To: freebsd-questions Message-ID: X-X-Sender: beerstud@spamcop.net@mail.cesmail.net MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new .250 at suscom.net Subject: Restarting MySQL from CRON X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Gerard Seibert List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 10 Sep 2005 16:12:32 -0000 >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? -- Gerard Seibert gerard-seibert@uscom.net