using LOAD DATA LOCAL INFILE

Help
2011-06-07
2012-09-19
  • Noel Hollings
    Noel Hollings
    2011-06-07

    I'm using code where I execute something like "LOAD DATA LOCAL INFILE
    'filename' INTO table ignore 1 lines(table values), but it's giving me the
    error _mysql_exceptions.OperationalError: (1148, 'The used command is not
    allowed with this MySQL version'). Does anyone know a fix for this? I've
    googled and most of the answers seem to be for SQL, not the python SQL
    libraries, so I am not sure how to get this working.