in reply to Net::MySQL will work load data local in file command

...or do i need to copy this file to server...
That's the way I would do it. How would the server know about C:\1.csv?