Re: How to export data from ZODB to MYSQL

"Jonathan" <[email protected]> Sun, 25 Feb 2007 11:28:41 -0500
Newsgroups gmane.comp.web.zope.database
Message-ID <002201c758fa$03797bf0$677ba8c0@DESKTOP>
<snip>
----- Original Message ----- 
From: Win Myint Aung
To: [email protected]
Sent: Sunday, February 25, 2007 10:43 AM
Subject: [Zope-DB] How to export data from ZODB to MYSQL

I am a newbie in Zope. Now I am looking for the ways to export data from 
ZODB to MYSQL.
please do me a favor.
</snip>

If you already have objects stored in the ZODB and want to move them to 
mysql, you could write an external method that accesses objects in the ZODB 
and writes the necessary fields/records into a file on the filesystem (then 
you can use the mysql command 'load data infile...' to populate a mysql 
table).


Jonathan