From owner-freebsd-questions@FreeBSD.ORG Tue Apr 7 12:53:09 2009 Return-Path: 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 570A91065687 for ; Tue, 7 Apr 2009 12:53:09 +0000 (UTC) (envelope-from dave.list@pixelhammer.com) Received: from smtp1.tls.net (smtp1.tls.net [65.124.104.104]) by mx1.freebsd.org (Postfix) with ESMTP id EDC748FC15 for ; Tue, 7 Apr 2009 12:53:08 +0000 (UTC) (envelope-from dave.list@pixelhammer.com) Received: (qmail 17048 invoked from network); 7 Apr 2009 12:53:04 -0000 Received: by simscan 1.2.3 ppid: 17019, pid: 17045, t: 1.3637s scanners: attach: 1.2.3 spam: 3.2.1 X-Spam-Checker-Version: SpamAssassin 3.2.1 (2007-05-02) on smtp1.tls.net X-Spam-Level: X-Spam-Status: No, score=0.2 required=7.0 tests=ALL_TRUSTED,TVD_RCVD_IP autolearn=disabled version=3.2.1 Received: from 64-184-9-159.bb.hrtc.net (HELO ?192.168.1.46?) (ldg@tls.net@64.184.9.159) by ssl-smtp1.tls.net with ESMTPA; 7 Apr 2009 12:53:03 -0000 Message-ID: <49DB4C9A.9010004@pixelhammer.com> Date: Tue, 07 Apr 2009 08:52:42 -0400 From: DAve User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <49DAC610.6020404@pixelhammer.com> <200904062037.30518.npapke@acm.org> In-Reply-To: <200904062037.30518.npapke@acm.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Multiple instances of MySQL 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: Tue, 07 Apr 2009 12:53:09 -0000 Norbert Papke wrote: > On April 6, 2009, DAve wrote: >> Has anyone setup two instances of MySQL on the same server? One running >> just a client's DBs? Any advice would be helpful. > > It's just a matter of making sure that the two instances don't share any ports > or files. It works well. You'll have to create a custom my.cnf file and > start-up script for your second instance. > That is as I suspected. Thanks. DAve -- "Posterity, you will know how much it cost the present generation to preserve your freedom. I hope you will make good use of it. If you do not, I shall repent in heaven that ever I took half the pains to preserve it." John Quincy Adams http://appleseedinfo.org