From owner-freebsd-questions@FreeBSD.ORG  Fri Aug 19 16:34:18 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 8E33A16A41F
	for <freebsd-questions@freebsd.org>;
	Fri, 19 Aug 2005 16:34:18 +0000 (GMT)
	(envelope-from algould@datawok.com)
Received: from smtpauth06.mail.atl.earthlink.net
	(smtpauth06.mail.atl.earthlink.net [209.86.89.66])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 40C6843D48
	for <freebsd-questions@freebsd.org>;
	Fri, 19 Aug 2005 16:34:18 +0000 (GMT)
	(envelope-from algould@datawok.com)
Received: from [206.255.31.21] (helo=grokwell.org)
	by smtpauth06.mail.atl.earthlink.net with asmtp (TLSv1:AES256-SHA:256)
	(Exim 4.34) id 1E69ov-0006Tg-M6; Fri, 19 Aug 2005 12:34:17 -0400
Date: Fri, 19 Aug 2005 11:34:17 -0500
From: "Andrew L. Gould" <algould@datawok.com>
To: "Mick Wilcoxen" <wwilcoxen@sbcglobal.net>
Message-ID: <20050819113417.406218b6@grokwell.org>
In-Reply-To: <000001c5a4d9$2e61ff80$6700a8c0@Zippy>
References: <20050819104929.1bc1a0d5@grokwell.org>
	<000001c5a4d9$2e61ff80$6700a8c0@Zippy>
X-Mailer: Sylpheed-Claws 1.9.11 (GTK+ 2.6.8; i386-portbld-freebsd5.4)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-ELNK-Trace: ee791d459e3d6817d780f4a490ca69563f9fea00a6dd62bcec668deaabb88a38f205341c824621d8350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 206.255.31.21
Cc: freebsd-questions@freebsd.org
Subject: Re: start up command for mysql
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 19 Aug 2005 16:34:18 -0000

On Fri, 19 Aug 2005 09:15:08 -0700
"Mick Wilcoxen" <wwilcoxen@sbcglobal.net> wrote:

> Hi Andrew,
> 
> Found it. But the command is different from the command that
> The person who created the database gave. Should I change it to mach
> his command 
> 
> The command there is 
> 
> Start)
> 	/sbin/idcongif -m /usr/local/lib/mysql
> 	;;
> Stop)
> 	;;
> *)
> 	echo ""
> 	echo " Usage: 'basename $0' {start | stop} "
> 	echo ""
> 	exit 64
> 	;;
> Esac
> 
> He is telling me to put this command in the startup
> 
> /usr/local/mysql/bin/safe_mysqld &.
> 
> Run this with the period at the end.put it in your start up script.
> 
> The database program.(the first of many  I have written) is based on
> PHP/Mysql
> 
> ***********************************************************
> Mick Wilcoxen
> (530)933-2882

The script you found does not start MySQL.  It just ensures that the
operating system can find the MySQL libraries.

The command you mention above starts MySQL; and can be added to the
"Start" section of the script. I've never put a period after the
ampersand; so I don't know what that will do.  (I switched from MySQL
to PostgreSQL over 5 years ago.)

The reason it would be good to find the script that is installed by the
port is that it probably has a "stop" section for shutting down MySQL
cleanly and removing the pid file when the operating system is being
shutdown.

Good luck,

Andrew Gould