Migrating Huge Tables (gigabytes)
Posted by: trobertson
Date: November 17, 2005 03:33AM

Hi
I'm trying to migrate a 10gig DB from mysql 4.1.15 to 5.1.
Some of the tables have 50million records.

The migration failed with out of memory (heap). Ive not spent much time on this yet but a quick look at the MigrationGeneric.doDataBulkTransferTableToMysql shows its trying to manage the insert in a memory buffer. I guess I need to change this for a start.

Anyone got any suggestions for a quick fix, or am I dreaming?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Migrating Huge Tables (gigabytes)
November 17, 2005 03:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.