title: MySQL LOAD DATA LOCAL INFILE Python
body: <p>I am running Ubuntu 12.04 and MySQL 5.5
  Alright so here is the problem:</p>
  
  <p>Using the MySQLDB module for Python, the SQL command:</p>
  
  <pre><code>cursor.execute("LOAD DATA LOCAL INFILE 'example.csv' INTO TABLE 'example_mysql_table' TERMINATED BY ',';")
  </code></pre>
  
  <p>Doesn't work. I get <code>ERROR 1148: The used command is not allowed with this MySQL version</code></p>
  
  <p>I have looked around for a solution for this for a while now, and so far it seems other people having the same problem have fixed it by adding "local-infile = 1" to 'my.cnf' underneath [mysqld] and [mysql]. This has not worked for me, and I am not sure why.</p>
  
  <p>Relevant Link:</p>
  
  <p><a href="https://stackoverflow.com/questions/10762239/enable-load-data-local-infile">MySQL: Enable LOAD DATA LOCAL INFILE</a></p>