[MonetDB-users] create database on different drive
Hi all, I’m having a few difficulties on a Windows server: - I want to move the dbfarm to another drive and have altered the gdk_farm setting in the etc\monetdb5.conf file: gdk_dbfarm=G:\MonetDB5\dbfarm. MonetDB server however keeps creating a new MonetDB dir in the ‘documents and settings’ directory, the last place where I want to store a database. Do I need to alter other settings, or is there another config file? - How do you create a new database (on the different drive) and connect to that one instead of the standard ‘demo’ db? Met vriendelijke groet/kind regards, Jos van Dongen Tholis Consulting T: 06-51169606 F: 0842-231136 M: jvdongen@tholis.com www.tholis.com No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.2/1224 - Release Date: 14-1-2008 17:39
On 2008-01-16 20:30, Jos van Dongen wrote:
Hi all,
I’m having a few difficulties on a Windows server:
- I want to move the dbfarm to another drive and have altered the gdk_farm setting in the etc\monetdb5.conf file: gdk_dbfarm=G:\MonetDB5\dbfarm. MonetDB server however keeps creating a new MonetDB dir in the ‘documents and settings’ directory, the last place where I want to store a database. Do I need to alter other settings, or is there another config file?
- How do you create a new database (on the different drive) and connect to that one instead of the standard ‘demo’ db?
You will need to edit the script M5server.bat in the program installation folder. -- Sjoerd Mullender
Sjoerd Mullender wrote:
On 2008-01-16 20:30, Jos van Dongen wrote:
Hi all,
I’m having a few difficulties on a Windows server:
- I want to move the dbfarm to another drive and have altered the gdk_farm setting in the etc\monetdb5.conf file: gdk_dbfarm=G:\MonetDB5\dbfarm. MonetDB server however keeps creating a new MonetDB dir in the ‘documents and settings’ directory, the last place where I want to store a database. Do I need to alter other settings, or is there another config file?
- How do you create a new database (on the different drive) and connect to that one instead of the standard ‘demo’ db?
You will need to edit the script M5server.bat in the program installation folder.
Instead of: if "%APPDATA%" == "" goto skip set MONETDBDIR=%APPDATA%\MonetDB5 You could do: MYDBFARM=G:\ set MONETDBDIR=%MYDBFARM%\MonetDB5 Regards, Romulo
participants (3)
-
Jos van Dongen -
Romulo Goncalves -
Sjoerd Mullender