Page 1 of 1

bulk import

Posted: 24.02.2006, 08:15
by davids
What's the fastest way to import 15,000 records into a MySQL table? I don't need to keep what's there previously.

FYI, I'm running D6 and have both Zeos 5.5 and Zeos Access installed. My server just got updated to run MySQL 5.0.

Thx
-David

Posted: 26.02.2006, 11:08
by mdaems
Hi David,

The fastest way is to use the mysqlimport tool from the mysql distribution. All information can be found in the mysql documentation. There's 1 prerequisite, the input data has to be formatted in a reasonable fashion. (there are some options but not all is possible)

Good luck,
Mark

Posted: 26.02.2006, 14:42
by zippo
I agree - that's far the fastest way.