From owner-freebsd-questions@FreeBSD.ORG  Sat Mar 26 22:56:03 2011
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 3F31A106566B
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Mar 2011 22:56:03 +0000 (UTC)
	(envelope-from fbsd8@a1poweruser.com)
Received: from mail-03.name-services.com (mail-03.name-services.com
	[69.64.155.195])
	by mx1.freebsd.org (Postfix) with ESMTP id 24F2B8FC13
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Mar 2011 22:56:02 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; q=dns/txt;
	s=DKIM-NAME-SERVICES; d=a1poweruser.com;
	h=From:To:Cc:Subject:Message-ID:X-Sender:X-Envelope-From; l=500;
	bh=GnSKbTwl6s4xmm9WFyrksW2IsGBNPgoICGIxASZou2s=; 
	b=DQpmL5b0NDscxVLRgLN5YBfgsXwEiMrtYybjJ8b+JRUZns/7WTiPNjvIcaxqOZEi05+PdiHiL4v4ELelEnElzp/kQ6RGYJbktwY2Omdtrc/qXAEyNgHzU2dNODsW+2SbsGBuFU1GHQ83kHI0pvo8aM7RbGo5a/V0kFg7mqJJ+wY=
Received: from [192.168.1.64] ([76.240.47.196]) by mail-03.name-services.com
	with Microsoft SMTPSVC(6.0.3790.4675); 
	Sat, 26 Mar 2011 15:56:03 -0700
Message-ID: <4D8E6F03.6060604@a1poweruser.com>
Date: Sat, 26 Mar 2011 18:56:03 -0400
From: Fbsd8 <fbsd8@a1poweruser.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
To: Laszlo Nagy <gandalf@shopzeus.com>
References: <20110326174100.1617.qmail@joyce.lan>	<4D8E3CA4.8040808@shopzeus.com>	<alpine.BSF.2.00.1103261650001.48941@joyce.lan>
	<4D8E5F5E.9080104@shopzeus.com>
In-Reply-To: <4D8E5F5E.9080104@shopzeus.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 26 Mar 2011 22:56:03.0156 (UTC)
	FILETIME=[FB619140:01CBEC08]
X-Sender: fbsd8@a1poweruser.com
X-Envelope-From: fbsd8*a1poweruser.com
Cc: freebsd-questions@freebsd.org
Subject: Re: MySQL 3 needed but how?
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: Sat, 26 Mar 2011 22:56:03 -0000

Laszlo Nagy wrote:
> 
>> Sounds like you'll have to do some debugging.  Try adding --verbose to 
>> mysql_args in /etc/rc.conf, and see the other advice in
>> http://dev.mysql.com/doc/refman/4.1/en/starting-server.html
> 
> gw# /usr/local/bin/mysqld_safe --verbose
> Starting mysqld daemon with databases from /var/db/mysql
> STOPPING server from pid file /var/db/mysql/gw.sznet.pid
> 110326 16:44:14  mysqld ended
> 
> The data directory is correct. I don't understand why it is stopping 
> immediatelly after startup.
> 
> Trying the other way around (FreeBSD 6.4 on a virtual machine)
>>
>> It may be something really simple, like the mysql data directory not 
>> being where the server expects it to be.
>>
> 
> 
No matter which version of mysql you install,
you have to run this command
mysql_install_db --user=mysql
on the command line to create mysql's
control databases first.
Then restart the mysql service.
To verify mysql is operational issue this command.
mysqladmin version
Them run your restore DB job pointing at your old bkup file.
That should recreate your db definition and populate the db
with your data in sync with the version of mysql your running.