Drupal 6 and LOAD DATA LOCAL INFILE
Even if the the remote MySQl server has the "local-infile = 1" in my.cnf and "SHOW GLOBAL VARIABLES LIKE 'local_infile';" shows local_infile = ON it can be cumbersome to run LOAD DATA LOCAL INFILE queries in Drupal 6.
I had to change to mysqli in the settings.php ($db_url = 'mysqli://....) and then modify database.mysqli.inc by adding the mysqli_option MYSQLI_OPT_LOCAL_INFILE.
This is in a closed environment so i did not have to think about the security issues: http://dev.mysql.com/doc/refman/5.1/en/load-data-local.html
$connection = mysqli_init();
mysqli_options($connection, MYSQLI_OPT_LOCAL_INFILE, true); //added to be able to run LOAD DATA LOCAL INFILE
@mysqli_real_connect($connection, $url['host'], $url['user'], $url['pass'], substr($url['path'], 1), $url['port'], NULL, MYSQLI_CLIENT_FOUND_ROWS);