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

Question

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

The csv file is probably about 20Gs.

thanks

Answer 1

consider using mysql LOAD DATA INFILE

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

Answer 2

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.