Thanks Stefan.

> Date: Fri, 2 Jan 2009 09:12:36 +0100
> From: Stefan.Manegold@cwi.nl
> To: monetdb-users@lists.sourceforge.net
> Subject: Re: [MonetDB-users] Multiple database question.
>
> On Fri, Jan 02, 2009 at 03:58:04PM +0800, 小波 顾 wrote:
> >
> > I have created a customed version of the MServer5.bat and MClient.bat to serve multiple databases.
> >
> > MServer5.bat :
> >
> > set MONETHOME=D:\Amber\Program\MonetDB\MonetDB5
> > set MONETDATAROOT=%1set MONETDATAROOT=%MONETDATAROOT:~0,-1%set MONETDBNAME=%2
> > if "%MONETDATAROOT%" == "" pauseif "%MONETDBNAME%" == "" pause
> >
> > set PATH=%MONETHOME%\bin;%MONETHOME%\lib;%MONETDB%\lib\MonetDB5;%PATH%
> >
> > set MONETDBFARM=--dbfarm="%MONETDATAROOT%\dbfarm"set SQLLOGDIR=--set "sql_logdir=%MONETDATAROOT%\sql_logs"set XQUERYLOGDIR=--set "xquery_logdir=%MONETDATAROOT%\xquery_logs"
> > rem start the real server"%MONETHOME%\bin\mserver5.exe" --set "prefix=%MONETHOME%" --set "exec_prefix=%MONETHOME%" %MONETDBFARM% %SQLLOGDIR% --dbname=%MONETDBNAME% --dbinit="include sql;"
> >
> > MClient5.bat
> >
> > @set MONETHOME=D:\Amber\Program\MonetDB\MonetDB5
> > @set DBNAME=%1if "%DBNAME%" == "" pause
> > @rem extend the search path with our EXE and DLL folders@rem we depend on pthreadVCE.dll having been copied to the lib folder@set PATH=%MONETHOME%\bin;%MONETHOME%\lib;%MONETHOME%\lib\bin;%PATH%
> > @rem start the real client@"%MONETHOME%\bin\mclient.exe" -lsql -d %DBNAME%
> > @if ERRORLEVEL 1 pause
> > Using "MServer5.bat D:\MONETDB amber" I am able to start a new server process, ant it successfully created a new database in D:\MONETDB directory, but with the new server and default demo server process all running, I can't use mclient connect to the new database.
> >
> > MClient5.bat amber
> >
> > D:\>mclient.exe -E GB2312 -lsql -d amber!database 'amber' does not exist
> >
> > But the demo database can be connected to, and the new database can be connected to only when I close the demo database process.
> >
> > The netstat -a command shows there are two processes listening on port 50000.
>
> Right: if you want to have more than one MonetDb servers running
> concurrently on one machine (each serving a different DB), you need to make
> sure they use different ports, e.g., by eplicitly specifying the MAPI port
> to be used on the mserver5 (and mclient) commandline:
>
> `mserver5 --set mapi_port=<portnr>`
>
> `mclient --port=<portnr>`
>
> Stefan
>
> >
> >
> > _________________________________________________________________
> > Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
> > http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
> > ------------------------------------------------------------------------------
>
> > _______________________________________________
> > MonetDB-users mailing list
> > MonetDB-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
> --
> | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
> | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
> | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
> | The Netherlands | Fax : +31 (20) 592-4312 |
>
> ------------------------------------------------------------------------------
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

---

check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages