Sorry I did not read carefully about your trying to load the file manually into mysql

. If it is not too hard to change the code, can you try to open a proper file handle (just by using  open (OUT, ">myfile"); and then write to this handle instead of the one generated by File::Temp? Also before you call dbh-do() can you  close(OUT) or die $!;? See if this makes any difference.