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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
According to http://dev.mysql.com/doc/refman/5.0/en/load-data-
local.html that
functionality is not enabled by default in the server as of, well, a long time
ago. It is not a MySQLdb issue.