what is the fastest method to upload a csv file into mysql via perl, mysql?
The csv file is probably about 20Gs.
thanks
consider using mysql LOAD DATA INFILE
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
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.
consider using mysql LOAD DATA INFILE
http://dev.mysql.com/doc/refman/5.0/en/load-data.html