db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Importing data from MySQL
Date Wed, 23 Mar 2005 00:01:17 GMT
Christian Rodriguez wrote:

>Hello everyone,
>I am trying to import data from a MySQL database. So far I havent been
>able to do it.
>What I have tried:
>1. Ive used the mysql dump utility to generate a file with inserts and
>then try to run that file from ij. One of my tables contain a large
>"text" object and the inserts fail, probably because of quote or
>double quote characters.
>2. Ive written a basic java program that uses jdbc to connect to MySQL
>and the Derby database and tries to import the data. The program fails
>with an out of error message when trying to import that problematic
>table that contains large character objects.
>3. Ive tried to use db2db migration tool. It fails with the same
>error: out of memory.
>So, has anyone been able to do this kind of thing? What do you
>recommend? Any hints, help, suggestions?
It might help to start java    with a bigger heap limit.

java -Xmx512M 

Christian , might you be willing to document what you find about
migrating from MySQL?  Even just some notes might be good.  I think it
might be really valuable to the community.   



View raw message