Date: Fri, 29 Jul 2005 22:14:53 +0200 From: "nanard" <nanard@tou.nu> To: <sellis@telus.net>, <freebsd-isp@freebsd.org> Subject: Re: multiple mysql servers Message-ID: <023401c5947a$2f15b580$1401a8c0@portable> References: <20050729170146.GA41622@telus.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi, You just have to specify a different port , different socket, and different data directory to run it a second mysql server on the same box. : I didn't try this but you can: - Copy /var/db/mysql /var/db/mysql2 (and give same owner/perm than the other) - Create a my.cnf in /var/db/mysql2 and configure it. - Copy /usr/local/etc/rc.d/mysql-server.sh to /usr/local/etc/rc.d/mysql-server2.sh - In /usr/local/etc/rc.d/mysql-server2.sh, change in it "mysql_dbdir" variable to the new path and set mysql_enable to YES directly in it. Other solutions that i did, is to configure JAILS. Regards ----- Original Message ----- From: "Sean Ellis" <sellis@telus.net> To: <freebsd-isp@freebsd.org> Sent: Friday, July 29, 2005 7:01 PM Subject: multiple mysql servers > Hello, > > 4.11-STABLE FreeBSD 4.11-STABLE #2: Fri May 13 17:43:58 PDT 2005 > > can anyone recommend a good online resource for implementing a second > mysql daemon on freebsd? > > Or, perish the thought, any gotchas with this, > > thanks, > > Sean > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?023401c5947a$2f15b580$1401a8c0>