Hi, all
I have to upload a file from a client Revolution application to a MySQL server, but I obtain the following error:
"ERROR 1148: The used command is not allowed with this MySQL version"
If I try with another client application (i.e. MySQL Query Browser) from the same machine it works.
In mySQL 5.0 reference manual there a section about Security Issues with LOAD DATA LOCAL and I think that the problem is the following:
#
By default, all MySQL clients and libraries in binary distributions are compiled with the --enable-local-infile option, to be compatible with MySQL 3.23.48 and before.
#
If you build MySQL from source but do not invoke configure with the --enable-local-infile option, LOAD DATA LOCAL cannot be used by any client unless it is written explicitly to invoke mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0).
Have you any suggestions about the solution with a Revolution Program?
Thanks in advance.
Riccardo
LOAD DATA LOCAL INFILE with MySQL
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller