Get objects from ZODB into MySQL

Diez B. Roggisch deets at nospam.web.de
Tue Apr 28 00:20:21 CEST 2009


TheIvIaxx schrieb:
> Hello, I have searched for some solution to getting the object data
> from a ZODB Data.fs file into something i can work with for MySQL.  So
> far, no such luck.  I can open the DB and poke around, but im not sure
> where or what to even poke :)
> 
> It was a simple plone site, with mainly Pages/Documents (the basic
> content type).  I would imagine getting the object information into
> some sort of csv or txt format would be easy.  I can't really find
> anything in the ZMI that would do what i need either.
> 
> Any ideas on this?  Where in the DB are these objects stored and how
> to retrieve them?

The ZODB is essentially a persisted object graph. Not more, not less. In 
other words: there is no way to extract any "raw" data, all are 
python-objects. To persist these, you need to write a serialization of 
these objects to something that you can process further. XML-pickling 
might be an option. Or you write some generic thing based on dir() or 
__dict__.

Diez



More information about the Python-list mailing list