From owner-freebsd-questions@FreeBSD.ORG Mon Mar 5 15:05:34 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 8611316A402 for ; Mon, 5 Mar 2007 15:05:34 +0000 (UTC) (envelope-from bg271828@yahoo.com) Received: from web53410.mail.yahoo.com (web53410.mail.yahoo.com [206.190.37.57]) by mx1.freebsd.org (Postfix) with SMTP id 4315713C4A7 for ; Mon, 5 Mar 2007 15:05:34 +0000 (UTC) (envelope-from bg271828@yahoo.com) Received: (qmail 80787 invoked by uid 60001); 5 Mar 2007 15:05:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=44t/bw88ViosEazHAqV0tScwnd8SvQGftpwrGL6sW0I9M7Xg94G1aG+9ZPryVT56wPPc3iKb6ZMnB6up82ASmSWuvfT18rAdnlfVFFPzi7yX8GMJIKj/DTqnZlk20bES363jhZDiDOWMi52VlUN+TnVM/HtWLVhY65s+qbe/Z6o=; X-YMail-OSG: bBZFgQUVM1llzsf0qRDwIRz.wNCnhkoiiLr.xxNZ Received: from [12.182.77.130] by web53410.mail.yahoo.com via HTTP; Mon, 05 Mar 2007 07:05:30 PST Date: Mon, 5 Mar 2007 07:05:30 -0800 (PST) From: "Dr. Jennifer Nussbaum" To: freebsd-questions@freebsd.org MIME-Version: 1.0 Message-ID: <31636.77056.qm@web53410.mail.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Starting MySQL with different database directory X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 05 Mar 2007 15:05:34 -0000 I hope this is the right place--i looked over the MySQL docs but they talk about a different startup practice than what FreeBSD uses. I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my MySQL data directory in a place other than /var/db/mysql. I thought i do this by copying the appropriate my.cnf into /etc/my.conf and adding a line like "datadir = /usr/local/mysql/var/" and making it readable to mysql user. But this doesnt work; when i restart MySQL its still using /var/db/mysql. So i looked at the mysql-server startup script in /usr/local/etc/rc.d and added to rc.conf "mysql_dbdir="/usr/local/mysql/var"". (I DON'T want to do it this way, because i really want my MySQL related configuration things in my MySQL configuration file, not split between there and my FreeBSD startup file. What if i need to start mysql in some other way? But for now im just trying to see what i can get to work.) This seemed to change something--mysqld had been running when i made this change and when I ran "mysql-server stop" it couldnt stop, because it was looking in /usr/local/mysql/var/foo.pid--i think this means it did register the change to the new directory. But i couldnt then start it, because when I run "mysql-server start" i get a "Can't connect to local MySQL server through socket '/tmp/mysql.sock'" error. What's the right way to do this? Again id really prefer to do this all through the my.cnf file, but this seems not to be getting read, at least for this reason. Thank you. Jen --------------------------------- Food fight? Enjoy some healthy debate in the Yahoo! Answers Food & Drink Q&A.