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

A better question would be why you would ever want to do that. — Brian Roach
– Brian Roach, Commented Mar 2, 2012 at 16:41
Restoring a backup, migrating DB hosts, set up a test instance, prepare for stress test evaluation, … — daxim
– daxim, Commented Mar 2, 2012 at 16:45
I'm with Brian - why do this through Perl? What's wrong with the standard loader or a purpose-built bulk-loader tool? — Richard Huxton
– Richard Huxton, Commented Mar 2, 2012 at 16:55

dweeves · Accepted Answer · 2012-03-02 16:40:29Z

12

consider using mysql LOAD DATA INFILE

answered Mar 2, 2012 at 16:40

dweeves

5,64524 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

joatis · Accepted Answer · 2012-03-02 18:12:39Z

1

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.

answered Mar 2, 2012 at 18:12

joatis

3,4551 gold badge19 silver badges13 bronze badges