Mailing List Archive

How to export data from ZODB to MYSQL
Hello,

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.

Thanks and regards,

Win Myint Aung

Student-Information Management
School of Engineering and Technology, AIT
Klong Luang, Pathumthani 12120,
Thailand
Mail Box 1272




____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
Re: How to export data from ZODB to MYSQL [ In reply to ]
> 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.
What is your use case? In general there are two possibilities:
1. You want to use standard relational database connectivity mechanisms
like described in zope book (look at relational database connectivity
at http://www.plope.com/Books/2_7Edition/)

2. You want to use MySQL instead of ZODB (alternative storage)

So, what do you want to do?

--
Maciej Wisniowski

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: How to export data from ZODB to MYSQL [ In reply to ]
<snip>
----- Original Message -----
From: Win Myint Aung
To: zope-db@zope.org
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

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db
Re: How to export data from ZODB to MYSQL [ In reply to ]
I want to export Zwiki contents from ZODB to MYSQL. Thanks

Aung

----- Original Message ----
From: Maciej Wisniowski <maciej.wisniowski@coig.katowice.pl>
To: Win Myint Aung <wma108@yahoo.com>
Cc: zope-db@zope.org
Sent: Sunday, February 25, 2007 11:24:39 PM
Subject: Re: [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.
What is your use case? In general there are two possibilities:
1. You want to use standard relational database connectivity mechanisms
like described in zope book (look at relational database connectivity
at http://www.plope.com/Books/2_7Edition/)

2. You want to use MySQL instead of ZODB (alternative storage)

So, what do you want to do?

--
Maciej Wisniowski



____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com