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?
>
>Thanks,
>Christian
>
>  
>
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.   

Thanks

Kathey



Mime
View raw message