bulk import

[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

[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

[zippo]

I agree - that's far the fastest way.