developers-list May 2005

developers-list@monetdb.org

6 participants
4 discussions

[Monetdb-developers] SQL upgrade instructions

by Sjoerd Mullender

I wrote the following text to help with upgrading the SQL database. I think something like this should be prominently displayed (or a prominently displayed pointer to the text) so that people read it *before* attempting to upgrade. Comments? Dumping the SQL database. ------------------------- Start the SQL Server and SQL Client as usual. In the SQL Client, type the following three commands. Type them without any extra white space: >.../dump.sql \D > That is, first a line consisting of a greater than symbol followed by the full (!) name of the file in which you want to store the dump. This will redirect future output to the file mentioned. Then a line consisting of just backslash-capital D. This command does the actual dump which is, because of the previous line, stored in the dump file. And finally a line with just a greater than symbol. This closes the file and redirects the output again to the screen. It is also possible to dump from the command line. Start a SQL Server, and then issue the command MapiClient -lsql -umonetdb -Pmonetdb --dump > dump.sql This command will connect to the SQL Server and dump the database into the file dump.sql in the current directory. Restoring the SQL database. --------------------------- After having dumped the database per the preceding instructions, it is possible to restore the database using the following commands. Start the SQL Server and SQL Client as usual. In the SQL Client, type the following command. <.../dump.sql That is, a less than symbol followed by the full (!) path name of the dump file that was produced using the dump instructions. It is also possible to restore from the command line. Start a SQL Server, and then issue the command MapiClient -lsql -umonetdb -Pmonetdb < dump.sql

17 years, 2 months

[Monetdb-developers] help! where i get manual

by liudawei

Hi: I am a starter on MonetDB,I am interesting in this excllent Database.My questions are is: 1) where I can get the manual of Monet Server and SQL Front End. best regards Peter Chen --------------------------------- Do You Yahoo!? 注册世界一流品质的雅虎免费电邮

17 years, 2 months

Re: [Monetdb-developers] Install MonetDB-server on SLES 9 64 bit

by Stefan.Manegold＠cwi.nl

Dear Maggie, Thank you very much for being interestedn in MonetDB, and please accept our apologies for the inconvenience you experience. Indeed, we don not have a precompiled install (RPM) for 64-SuSE, yet; you could try the Fedora Core version, but I have no idea, whether it will work on SuSE... The yacc/lex errors you see can savely be ignored. The linker error is the real problem. Unfortunately, I cannot say right now, what the problem is, but it might be related to whether you have your SuSE system installed/configure to support the development/compilation of both, 322- and 64-bit programs (basically, are the system libraries available in both vorsions, or only in one). By default, MonetDB (tries to) compile 32-bit, even on a 64-bit Linux system (admittedly, this is not necessairly intuitive, but we haven't found time, yet, to change this...). To compile for 64-bit, you nedd to run configure with the "--enable-bits=64" option. Hence, my questions would be a) Do you know, whether your system has both 32-bit and 64-bit libraries installed? b) Did you run configure with or without the "--enable-bits=64" option? I hope, that these information will help us, to locate and solve the problem. Kind Regards, Stefan > I have looked for a precompiled install for Suse 9 64 bit but alas cannot > find one, so I changed to compiling from source and during the make I am > getting the following errors > > conflicts: 32 reduce/reduce > conflicts: 32 reduce/reduce > y.tab.c: In function `int yyparse()': > y.tab.c:1868: warning: label `yyerrlab1' defined but not used > /usr/lib64/libbz2.so: could not read symbols: Invalid operation > collect2: ld returned 1 exit status > make[4]: *** [libstream.la] Error 1 > make[3]: *** [all] Error 2 > make[2]: *** [all-recursive] Error 1 > make[1]: *** [all-recursive] Error 1 > make: *** [all] Error 2 > > any help would be greatly appreciated. > > Maggie > > > > ------------------------------------------------------- > SF.Net email is sponsored by: GoToMeeting - the easiest way to collaborate > online with coworkers and clients while avoiding the high cost of travel and > communications. There is no equipment to buy and you can meet as often as > you want. Try it free.http://ads.osdn.com/?ad_id=7402&alloc_id=16135&op=click > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > > > -- | 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 |

17 years, 2 months

[Monetdb-developers] Install MonetDB-server on SLES 9 64 bit

by Margaret E Johnson

I have looked for a precompiled install for Suse 9 64 bit but alas cannot find one, so I changed to compiling from source and during the make I am getting the following errors conflicts: 32 reduce/reduce conflicts: 32 reduce/reduce y.tab.c: In function `int yyparse()': y.tab.c:1868: warning: label `yyerrlab1' defined but not used /usr/lib64/libbz2.so: could not read symbols: Invalid operation collect2: ld returned 1 exit status make[4]: *** [libstream.la] Error 1 make[3]: *** [all] Error 2 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 any help would be greatly appreciated. Maggie

17 years, 2 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

developers-list May 2005