Hello Lowterm, Thanks for using MonetDB and sorry for the delayed reply. Many members of the group are on traveling, including our only Windows expert. To create a new database, you can use the option of mserver5.exe: --dbname="<name of the database you want to create>" On Windows, I don't know a better way than editing the M5server.bat script. On a Win XP, this script can be found in "C:\Program Files\MonetDB\MonetDB5". So for instance, I have edited my M5server.bat as the following: "%MONETDB%\bin\mserver5.exe" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" %MONETDBFARM% %* --dbname="test" i.e., '--dbname="test"' has been added. Then you can just use the shortcuts in the start menu to start the MonetDB SQL server and client. In the MonetDB SQL client, you can use the command "\?" to get a list of commands available, among others, the command "\<" allows you to read input from file. I hope this helps a bit. With kind regards, Jennie On May 19, 2011, at 10:14 , Lowterm wrote:
Hi,
how can I create a new Database under Windows and how can I load data in a table form a external file?
Thanks -- View this message in context: http://old.nabble.com/Create-Database---Load-Data-tp31653813p31653813.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users