Hello Win, I think you'll have to write a script. Have a look at http://svn.zope.org/z3c.zodbbrowser/sandbox/src/z3c/zodbbrowser/ From plugin_fs.py you can extract how to open the ZODB without zope. You can then traverse (access the properties) of the root and object thereunder.
Matching an OODB with an RDB might not be a simple task as the OODB is a tree or a graph of objects. As Lennart already said on the list: But the best way to export data from ZODB is to write a script which outputs CSV values, which you then can import to MySQL. (Note that ZODB is not a type of SQL database but an object oriented database, and that a generic export therefore is not possible, you must write a dedicated script for your specific data set. This however is usually quite easy). Tuesday, March 6, 2007, 4:08:45 AM, you wrote: WMA> Hello Adam, WMA> I would like to request you to help me if possible. I am tryiny to WMA> export contents (text data) of objects in ZODB. But I am a newbie and WMA> no idea to do that. Could you please show some ways with exact WMA> instruction? I am a bit hurry to do that. WMA> Thank you for your attention and time. WMA> Kind regards, WMA> Win Myint Aung WMA> Quoting Adam Groszer <[EMAIL PROTECTED]> on 03/06/07: >> Hello Christian, >> >> It's mostly done. Available at z3c.zodbtracing as inbetween I figured >> out that tracing the connection should be also possible. >> >> Saturday, February 24, 2007, 8:00:40 PM, you wrote: >> >>> Hi, >> >>> I'm pretty sure there are no hooks around that do what you need. >> >>> The methods you want to tap into would be >> >>> store() >>> load*() >> >>> on the storages. >> >>> You might want to look into how the BlobStorage was created to make >>> yourself a "tracing storage" that can be wrapped around an existing >>> storage to allow usage with multiple other storages. >> >>> This could be a useful extensions to ZODB. If you go this way, I'd be >>> happy to help out with some of the packaging mechanics and getting the >>> ZConfig parts fletched out. >> >>> Christian >> >>> Am Samstag, den 24.02.2007, 14:33 +0100 schrieb Adam Groszer: >>>> Hello, >>>> >>>> I'm using ZODB in a GUI application, so outside of Zope. >>>> >>>> I'm having performance problems. I'm already on the way of figuring >>>> out what causes a lot of object load. getTransferCounts helped in >>>> that. But now I would need something more detailed. >>>> >>>> Are there any hooks or something to get detailed object load >>>> statistics? >>>> Worst case I could hook into some methods of ZODB temporarly to >>>> collect the data, but into which methods? >>>> >>>> Any help or pointers are welcome. >>>> >> >> >> >> -- >> Best regards, >> Adam mailto:[EMAIL PROTECTED] >> >> _______________________________________________ >> For more information about ZODB, see the ZODB Wiki: >> http://www.zope.org/Wikis/ZODB/ >> >> ZODB-Dev mailing list - ZODB-Dev@zope.org >> http://mail.zope.org/mailman/listinfo/zodb-dev >> WMA> Master Student-Information Management WMA> School of Engineering and Technology, AIT WMA> Klong Luang, Pathumthani 12120, WMA> Thailand WMA> Mail Box 1272 -- Best regards, Groszer Adam mailto:[EMAIL PROTECTED] -- Quote of the day: Love is a matter of chemistry, but Sex is a matter of physics. _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev