[thelist] MySQL Load Data Local Infile question

Ed McCarroll Ed at ComSimplicity.com
Wed Jan 22 16:18:00 CST 2003


I've just installed MySQL v4.0.9-gamma-max-nt on my Win2K machine.
When I try to do a "Load Data Local Infile", I get an error msg:

  "ERROR 1148: The used command is not allowed with this MySQL version"

The manual says this syntax is available after version 3.22.6, but that:

  "In the case that LOAD DATA LOCAL INFILE is disabled in the server or
   the client, you will get the error message (1148)"

WinMySQLadmin says that my local_infile variable is set to "ON", but
I don't know if this relates to the server, or the client (which both
happen to be the same machine).

Can anybody tell me what I've done wrong?  (TIA)

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                          MailTo:Ed at ComSimplicity.com
ComSimplicity                                      (310) 838-4330
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -





More information about the thelist mailing list