perl, mysql - fasting way to upload a csv file into mysql?

498 views Asked by At

what is the fastest method to upload a csv file into mysql via perl, mysql?

The csv file is probably about 20Gs.

thanks

2

There are 2 answers

0
dweeves On BEST ANSWER

consider using mysql LOAD DATA INFILE

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

0
joatis On

You could use Perl and DBI to execute a LOAD DATA INFILE statement, if for some reason you couldn't use the mysql client or mysqladmin.