Hi Jim, > There's a dump of the MySQL database on www.freedos.org...
I had guessed / feared that ;-) So now I spent half of the night installing MySQL (because SF uses it) and PosgreSQL (because I use it) and DDL-UTILS (which convert between many databases and XML) on my PC, failing with the latter because I had the daring idea to get the SVN version and not a precompiled one. Will keep trying... After learning a bit of MySQL, I found out how to import the dump on my PC, dump again to XML with binary blobs as hexdump. This gives me a plain text XML file :-). I did some looking around in the tables, and the "bugs" and "longdesc" ones seem to be the most useful ones, although there is a pile of others because Bugzilla is overly configurable ;-). So I am learning which format we HAVE from Bugzilla. Next question is of course, which format do we NEED for importing (the most useful parts of) the data into some sourceforge tracker database? Did the SF people tell you details about that? Of course I could always convert into some cut and paste friendly format or something, or maybe you could write a CGI which takes the data after I convert it and fills it into the html/http forms of the tracker? > The guys at SourceForge say there's isn't a way to do it... Nothing is impossible :-p > write a program to do all the cross-mapping of the fields to > put it in a format the Trackers would understand. Thats what I planned to do, but I think it is okay to drop some fields while doing so. > Yet I don't want this to delay our decisions on moving off Bugzilla > www.freedos.org. I waited for over a year for SourceForge... How about moving Bugzilla to another server? Tassilo / Berlios / ...? And of course, how about just upgrading Bugzilla? I hope it will be able to convert its own old-formatted data somehow? > bugs and "push" it into the SF Tracker "submit" forms: I thought about > it, and I'm not thrilled with that idea. It loses all the date data Hmm okay. So we better make a data file which can be imported by SF. > To do it right, you have to modify the SF Tracker database > programmatically with our bugzilla data, and no one but SF > has access to the SF Tracker databases. Which is a good idea for safety reasons. I assume they still will accept tracker data in some file format or another. > What I need is to reduce the amount of time I spend doing this kind > of maintenance stuff on the web site. And working on upgrades & > workarounds to the bugzilla system (on www.freedos.org or any other > site) is time-consuming maintenance, uninteresting stuff... So we need either conversion to trackers or another Bugzilla hoster. Installing new Bugzilla from scratch is not overly complex, have done that at work already. But I never migrated existing bug data from old to new, from server X to server Y. Eric ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Freedos-devel mailing list Freedos-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freedos-devel
