From owner-freebsd-questions@FreeBSD.ORG Tue Apr 7 03:37:32 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 CC5DA10657FC for ; Tue, 7 Apr 2009 03:37:32 +0000 (UTC) (envelope-from npapke@acm.org) Received: from idcmail-mo2no.shaw.ca (idcmail-mo2no.shaw.ca [64.59.134.9]) by mx1.freebsd.org (Postfix) with ESMTP id 97B328FC14 for ; Tue, 7 Apr 2009 03:37:32 +0000 (UTC) (envelope-from npapke@acm.org) Received: from pd6ml2no-ssvc.prod.shaw.ca ([10.0.153.163]) by pd5mo1no-svcs.prod.shaw.ca with ESMTP; 06 Apr 2009 21:37:32 -0600 X-Cloudmark-SP-Filtered: true X-Cloudmark-SP-Result: v=1.0 c=0 a=tekm_XskAAAA:8 a=dbxxcAQLOEyj0SgsqMkA:9 a=2KeUOJEMAdyE4LAUM4XDBexkaXgA:4 a=nAPXUAfsBmEA:10 Received: from s010600121729c74c.vc.shawcable.net (HELO proven.lan) ([24.85.241.34]) by pd6ml2no-dmz.prod.shaw.ca with ESMTP; 06 Apr 2009 21:37:32 -0600 Received: from proven.lan (localhost [127.0.0.1]) by proven.lan (8.14.3/8.14.3) with ESMTP id n373bV03083955 for ; Mon, 6 Apr 2009 20:37:31 -0700 (PDT) (envelope-from npapke@acm.org) Received: from localhost (localhost [[UNIX: localhost]]) by proven.lan (8.14.3/8.14.3/Submit) id n373bVo8083954 for freebsd-questions@freebsd.org; Mon, 6 Apr 2009 20:37:31 -0700 (PDT) (envelope-from npapke@acm.org) X-Authentication-Warning: proven.lan: npapke set sender to npapke@acm.org using -f From: Norbert Papke Organization: Archaeological Filing To: freebsd-questions@freebsd.org Date: Mon, 6 Apr 2009 20:37:30 -0700 User-Agent: KMail/1.9.10 References: <49DAC610.6020404@pixelhammer.com> In-Reply-To: <49DAC610.6020404@pixelhammer.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200904062037.30518.npapke@acm.org> 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 03:37:33 -0000 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. More info: http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html Remember to specify the alternate port when using programs such as 'mysql' command line client. Cheers, -- Norbert Papke. npapke@acm.org