MySQL Load Data Local
Michael Caufield
mcaufield at hoosierstamping.com
Thu Aug 3 10:43:33 EDT 2006
From Revolution version 2.7.2 forward the MySQL Load Data Local
Infile command fails with the error message "The used command is not
supported by this version of MySQL. The current version of MySQL
server being used is 5.0.21. This command works from the MySQL
command line without fail. It also works when called from
revExecuteSQL for versions of Revolution up to 2.7.1. I believe the
problem is caused by the fact that the MySQL driver is now linked
against the latest version of the MySQL client library (5.0.23) and
has been compiled with the --local-infile=0. Is this behavior
intentional? I think that the default for the MySQL client is to set
this flag to true. As a workaround, can the MySQL driver from version
2.7.1 be used in newer versions of Revolution? Please advise.
More information about the use-livecode
mailing list