[Zope] using mysql LOAD command to store values into table from zope mgt screen (is it realistics?)

[Hamzat Kamal]

Hi,

I have my zope server and mysql server at the remote site.

I can logged in to my zope server from my local computer but yet to be able
to log into mysql server.

I have already created a table into database inside mysql server at the
remote site through the Mysql database adapter (MySQLDA) created inside the
zope server.

I didn't want to use INSERT COMMAND to store values into this table (for
obvious reasons) so i would have preferred LOAD command. I have already
tried these ffg. from the MySQL Database Connection management screen but
all failed..

LOAD DATA FROM "C:\text.txt" INTO TABLE test
error :ProgrammingError
Error Value: (1064, 'You have an error in your SQL syntax near \'from
"c:\\text.txt" into table test\' at line 1')

LOAD DATA LOCAL INFILE "text.txt" INTO TABLE test
LOAD DATA LOCAL INFILE "c:\text.txt" INTO TABLE test
error:The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request POST /jambng_db/manage_test.
Reason: Document contains no data



Please assist.

regards.

kamal