I have scoured the archives and reconfigured my.ini with:
Set-variable = local-infile=1
I have tried it on the command line tooand still I get the dreaded
"command not valid for this version of MySQL" error.
I am using:
WinXP Pro/IIS
MyODBC driver 3.51
MySQL 3.23.58 - I cant go to 4 but the problem is still the same. I didnt
see a fix for it there.
I have read the link in the docs:
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
I found one curious post that I could not try all of because I did not know
what it meant which *seemed* to identify the problem:
You need to add 65536 to your option value in the connection string.
This will instruct the ODBC driver to apply any settings per C:\my.cnf file.
Furthermore, you will need either a [client] or [odbc] section in the my.cnf
file.
Within that section you will need a line that sets local-infile=1
I confess I do not know what the first instruction is but, so far, I have
not been able to LOAD OR do a mysqulimport without getting the same error.
Past including the variable line in my.ini I was not able to find anything
else in the archives.
Any other ideas
Thanks,
Anne
Toronto, Ont.