The code you show cannot be used for loading the data from your file, as it has several errors.

Please show us the actual, reduced code you are using, not something that cannot run without errors.

For solving your problem, consider looking at the LOAD DATA INFILE command of MySQL.

As an alternative, look at the execute_for_fetch method of DBI.