Mark, Try your hardest to use the LOAD procedure. Though I have not done it in MYSQL yet, I have found with other databases, that the load procedures are always faster than doing an insert a record at a time. I have taken a DB2 database and used inserts to insert the records one at a time into a mysql database, it took like 8 - 12 hours to run for around 15 million very wide records (can't remember exact time, do to many loads ;-).
John Herbold IS Specialist/DBA -----Original Message----- From: Mark Riehl [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: Transferring from Access to MySQL All - We've got several Access databases that have ~2 million records and each record has ~20 fields. Looking for the most efficient way to do this. As far as I can tell, I have two options: 1. Open a connection to each database, select * from the Access table, then push each row into MySQL. 2. Export the table from Access, then use a load data file to pull it into MySQL. Each of the exported files is ~ 1 GB. Any other suggestions? How would you do this? Thanks, Mark - Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED]
