i have a drupal site that tried to load a user uploaded file into the database using the "LOAD DATA LOCAL INFILE" command. after migrating to a new server that has:
mysql Ver 14.14 Distrib 5.5.32, for debian-linux-gnu (i686) using readline 6.2
i get the following error when trying to execute the code: " The used command is not allowed with this MySQL version: LOAD DATA LOCAL INFILE "
i did some research and it seems there are two viable solutions:
1- recompile mysql with the load-infile option enabled (not possible in my case"
2- modify the connection settings to add "mysqli_options($link, MYSQLI_OPT_LOCAL_INFILE, true);" as per the following post: http://ubuntuforums.org/showthread.php?t=1970615
i found in the drupal 7 changelog that connection options settings have been modified to allow users to add options in settings.php but i cannot find any examples on how to specify connection options in settings.php
any suggestion would help greatly.