Just a few thoughts:

Keep an eye on the database log. Are there any errors?

Try loading just a handful of rows first to make sure the whole setup works.

Your statement reeks of mysql: does it run your 'query' in a transaction? Perhaps you just need to COMMIT?

Googling show sthat not all mysql server setups allow load data local. Perhaps you're out of luck?

mysql_local_infile

As of MySQL 3.23.49, the LOCAL capability for LOAD DATA may be disabled in the MySQL client library by default. If your DSN contains the option "mysql_local_infile=1", LOAD DATA LOCAL will be enabled. (However, this option is *ineffective* if the server has also been configured to disallow LOCAL.)