Appending 440k records to MySQL through ODBC
Hi!
I'm creating a script to merge a remote MySQL db with data from a local access backend. The problem occurs when I need to append a table with 440k records from Access to MySQL.
I removed all indexes except the PK from the MySQL table, but it fails halfway due to lack of free RAM.
I could move to a better pc, but I think there should be a better way. Exporting to a csv and import it in MySQL is an option, but that is trickier to include in a script (and the file is large too: 68MB!)
Can you give me some hints to get this done? Using 3.51 connector and 4.1.20.
Subject
Views
Written By
Posted
Appending 440k records to MySQL through ODBC
3588
November 05, 2009 03:40AM
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.