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