Date: Sat, 30 Jul 2005 07:30:46 -0700 From: Sean Ellis <sellis@telus.net> To: Sunil Sunder Raj <unixtools@hotmail.com> Cc: freebsd-isp@freebsd.org Subject: Re: multiple mysql server Message-ID: <20050730143046.GG41622@telus.net> In-Reply-To: <BAY106-F33541D45B17A9A2FED351BAEC10@phx.gbl> References: <20050729222540.GD41622@telus.net> <BAY106-F33541D45B17A9A2FED351BAEC10@phx.gbl>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, Jul 30, 2005 at 07:29:12AM +0000, Sunil Sunder Raj wrote: Hi Sunil, thanks for your reply. My need for a second mysql server is to allow me to implement a database that will use the utf-8 character set, whilst maintaining some existing databases that are using the default Latin1 character set. I've ammended what you suggest below based on what I've read in the documentation. Does this look sound? Anybody? I realize that this is more of a mysql question. > 1) install mysql Build with --with-extra-charsets to include utf-8 > 2) copy the mysql data directory to say mysql1 > So you have /var/db/mysql and /var/db/mysql1 > > 3) Open the first mysql /var/db/mysql/my.cnf > Change > port = <The port you want the first mysql to listen to> > bind-address = <The ip you want the first mysql to bind to> > > 4) start the first mysql server > > 5) Open the second mysql /var/db/mysql1/my.cnf > Change > port = <The port you want the second mysql to listen to> > bind-address = <The ip you want the second mysql to bind to> > > 6) Write the startup command for the second mysql server > /usr/local/bin/mysqld_safe --bind-address=<The ip address you want to bind > the second mysql server to> --user=mysql --socket=/tmp/mysql1.sock > --datadir=/var/db/mysql1 --pid-file=/var/run/mysql1.pid --default-character-set=utf8 --default-collation=utf8_general_ci & Easy enough for me to try out on a test machine. If anyone has any comments though I would be interested, cheers, Sean
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050730143046.GG41622>