From owner-freebsd-database Wed Oct 25 1:33:47 2000 Delivered-To: freebsd-database@freebsd.org Received: from pro.lookanswer.com (unknown [195.66.202.99]) by hub.freebsd.org (Postfix) with ESMTP id 0FB9637B479 for ; Wed, 25 Oct 2000 01:33:41 -0700 (PDT) Received: by pro.lookanswer.com (8.11.0/8.9.3) id e9P8XD971748; Wed, 25 Oct 2000 11:33:13 +0300 (EEST) (envelope-from havoc) From: Alex Koshterek To: Kazu Kimura Subject: Re: Question on MySQL Date: Wed, 25 Oct 2000 11:29:29 +0300 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain; charset="US-ASCII" Cc: Emil Thelin , freebsd-database@FreeBSD.ORG References: <20001025163220.3465.KIMURA@ctc.ad.jp> <00102510555600.71677@pro.lookanswer.com> <20001025171846.3468.KIMURA@ctc.ad.jp> In-Reply-To: <20001025171846.3468.KIMURA@ctc.ad.jp> MIME-Version: 1.0 Message-Id: <00102511331300.71744@pro.lookanswer.com> Content-Transfer-Encoding: 8bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG ср , 25 окт 2000, Kazu Kimura написал: > On Wed, 25 Oct 2000 10:54:29 +0300 > Alex Koshterek wrote: > > > > > > > > Maybe mysql server find database in incorrect place? > > Is following any conflict? > > red# grep mysql /etc/passwd > mysql:*:88:88:MySQL Daemon:/var/db/mysql:/sbin/nologin > red# ls /var/db/mysql > my.cnf red.err > > red# ls -l /usr/local/bin/mysql/data > total 2 > drwx------ 2 root wheel 512 Oct 25 11:27 mysql > drwx------ 2 root wheel 512 Oct 25 11:27 test > > red# ls /usr/local/bin/mysql/data/mysql > columns_priv.ISD func.ISD tables_priv.ISD > columns_priv.ISM func.ISM tables_priv.ISM > columns_priv.frm func.frm tables_priv.frm > db.ISD host.ISD user.ISD > db.ISM host.ISM user.ISM > db.frm host.frm user.frm > By default mysql search databases in /var/db/mysql Also in MySQL startup script you can write before starting server: datadir=/path/to/your/databases Alex To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message