Mailing List Archive: Zope: DB

How to export data from ZODB to MYSQL

Index | Next | Previous | View Threaded

wma108 at yahoo

Feb 25, 2007, 7:43 AM

Post #1 of 4 (1328 views)
Permalink

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

maciej.wisniowski at coig

Feb 25, 2007, 8:24 AM

Post #2 of 4 (1193 views)
Permalink

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[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

dev101 at magma

Feb 25, 2007, 8:28 AM

Post #3 of 4 (1198 views)
Permalink

Re: How to export data from ZODB to MYSQL [In reply to]

<snip>
----- Original Message -----
From: Win Myint Aung
To: zope-db[at]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[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

wma108 at yahoo

Feb 25, 2007, 5:41 PM

Post #4 of 4 (1182 views)
Permalink

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[at]coig.katowice.pl>
To: Win Myint Aung <wma108[at]yahoo.com>
Cc: zope-db[at]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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com