[Monetdb-developers] SQL upgrade instructions

Sjoerd Mullender sjoerd at acm.org
Fri May 27 11:47:43 CEST 2005

Fabian wrote:
> Sjoerd Mullender wrote:
>>> Perhaps it is better not to give the reader too many options 
>>> (confusing).  I'd prefer only giving the MapiClient --dump option, as 
>>> it is much more clear to the user what is happening.
>> Perhaps it is.  On the other hand, it would be good to document 
>> *somewhere* the different techniques.  Also, the \D way of doing 
>> things is handier for Windows users since the commandline interface is 
>> not readily available.
> Ok, I see your point.  What about making a clear distinction between 
> Windows and normal users?

That's a possbility.

>>> I will change the ebuild such that it refuses to update if the 
>>> var/MonetDB/ directory isn't empty and suggests to do the update as 
>>> written above.  It would be nice if this would be available somewhere 
>>> on the web for that purpose.
>> Not good, see below.
> /me looks below
>>> Is there a way to dump/restore MIL stuff?
>> You do that from the *new* installation:
>> Mserver (with *new* database--the default dbfarm should be changed)
>> module(upgrade);
>> convert("/.../bat");
>> commit();
>> quit();
> yeah, but I just want to 'backup' my data and archive it.  I don't want 
> to convert anything, I just want to store it in a save place.  I was 
> just wondering whether there was some other option than copying the BATs.

The document I wrote is secifically intended (althouth it doesn't 
explicitly say so) for upgrading to the new release.

For MIL users, the perhaps the easiest way is using the module(upgrade) 
stuff above.  For SQL users that is not possible since there are 
additional changes to the way SQL stores information in the database. 
For those users a dump/restore is the only option, and that option is 
described in the document.

Backing up your data and possibly restoring it later is also a 
worthwhile goal, however that was not the primary focus of this document.

>> repeat for each database within the farm.
> Ok.  I don't see the problem in an ebuild that refuses to update unless 
> you clean your /var/MonetDB/(dbfarm|log).  This way I can message the 
> user upfront that it should do something to preserve it's data. Pointing 
> to a nice migration website with some FAQ should do the trick...
> Q: I updated MonetDB and now if I start it, it repeatedly complains 
> about 'invalid BAT' or something.  What's up?
> A: The BAT format has changed to a new structure which is incompatible 
> with old structures.  Either remove your old databases or migrate them, 
> see [todo:migration page]
> Q: I updated MonetDB/SQL and now I cannot start it.  The log file says 
> something about 'incompatible database format'.  What should I do?
> A: The SQL catalog database has changed, and is incompatible with its 
> previous version.  If you don't care about your data you should clean 
> out your dbfarm, if you do, you have a problem.  Reinstall the previous 
> version of MonetDB/SQL and dump your database as described here 
> [todo:migration SQL page].  Reinstall the newest version and restore 
> your database.
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

Sjoerd Mullender

More information about the developers-list mailing list