3 messages in com.mysql.lists.win32LOAD DATA LOCAL file..scoured the arc...
FromSent OnAttachments
Anne Gibson17 Dec 2003 10:21 
Paul DuBois17 Dec 2003 13:00 
Anne Gibson17 Dec 2003 13:49 
Subject:LOAD DATA LOCAL file..scoured the archives
From:Anne Gibson (chey@gncom.com)
Date:12/17/2003 10:21:09 AM
List:com.mysql.lists.win32

I have scoured the archives and reconfigured my.ini with: Set-variable = local-infile=1

I have tried it on the command line too—and 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 can’t go to 4 but the problem is still the same. I didn’t 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.