I have been trying to load the textual contents of a file from my hard drive
space into a field (Description) of my mySQL table (Software) using the
follwing query. The query runs succfessfully, however, none of the contents
are loaded into the field, in fact, the Description field is not
I have been trying to load the textual contents of a file from my
hard drive
space into a field (Description) of my mySQL table (Software) using the
follwing query. The query runs succfessfully
How do you know that it's successful? What success/error codes
(if any) are returned?
cut
UPDATE Software SET Description =
LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
WHERE ID = 9
You have to make sure that not only can mysql read the file, but it also has
permissions to the directories that the files are in. Typically your home
directory on your
On Wed, 21 Nov 2001 17:02:29 -0500, Christopher Book [EMAIL PROTECTED] wrote:
UPDATE Software SET Description =
LOAD_FILE(/usr2/home/khan/www/cgibin/protecting/Describe/description_file)
WHERE ID = 9
You have to make sure that not only can mysql read the file, but it also has
permissions to
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
I have been trying to load the textual contents of a file from my
hard drive
:08 PM
Subject: Re: LOAD_FILE does not work
- Original Message -
From: Carsten H. Pedersen [EMAIL PROTECTED]
To: Sharaaz Khan [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 21, 2001 1:52 PM
Subject: RE: LOAD_FILE does not work
I have been trying to load