LOAD DATA LOCAL INFILE with MySQL

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
riccardo
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 13
Joined: Sat Apr 15, 2006 10:03 am
Location: Italia

LOAD DATA LOCAL INFILE with MySQL

Post by riccardo » Wed Jan 24, 2007 6:04 pm

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

Post Reply

Return to “Databases”