title: Error 1148 MySQL The used command is not allowed with this MySQL version
body: <p>I am using MySQL <code>LOAD DATA LOCAL INFILE</code> command and I get this error:</p>
  
  <pre><code>PDOException: SQLSTATE[42000]: Syntax error or access violation: 1148 The used 
  command is not allowed with this MySQL version: LOAD DATA LOCAL INFILE 
  '/tmp/phpI0ox54' INTO TABLE `dev_tmp` FIELDS TERMINATED BY ',' ENCLOSED 
  BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES; Array ( ) in 
  dc_real_estate_form_submit() (line 147 of /PATH/TO/PHP/SCRIPT).
  </code></pre>
  
  <p>What setting can we change to allow LOAD DATA LOCAL infile?</p>
  
  <p>Here is the Drupal 7 code we are using:</p>
  
  <pre><code>$sql = "LOAD DATA LOCAL INFILE '".$file."'
      INTO TABLE `dev_tmp`
      FIELDS
          TERMINATED BY ','
          ENCLOSED BY '\"'
      LINES
      TERMINATED BY '\\r\\n'
      IGNORE 1 LINES";
  
  db_query($sql);
  </code></pre>