, 2006 11:21 PM
Subject: Re: load-file() doesn't work [SOLVED]
Hi Fleet
[EMAIL PROTECTED] wrote:
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUTION:
The image file
[EMAIL PROTECTED] wrote:
I'm using MySQL 3.23.36 on RH 7.1. I've created a table photos (in
database album) with the following colums:
ID NUM AUTO_INCREMENT PRIMARY KEY
IMAGE MEDIUMBLOB
I'm running mysql from the command line:
mysql -u root
'root' has all privileges.
The file I'm trying to
Fleet, I'd also humbly suggest that the version you're using is VERY
old and you should update to at least the latest 3.23 (3.23.58 I
think), or 4.x, or maybe even 5.0 (production since last Fall).
Untold numbers of bugs fixed since 3.23.36.
Dan
On 7/17/06, Chris [EMAIL PROTECTED] wrote:
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie /image.jpg or /tmp/image.jpg. (At least in
Hi Fleet
[EMAIL PROTECTED] wrote:
SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));
Produces no error; but fails to load the image file.
SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie
On Mon, 17 Jul 2006, Marc Alff wrote:
Just to check, is the /home partition actually mounted on the server,
and at the same place ?
In other words, does /home/fleet/image.jpg exists :
- when seen from the host running mysql
- when seen from the host running mysqld
In answer to the above:
That should work just fine (although you should end the line with ; and
not l)
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 3:54 AM
To: [EMAIL PROTECTED]
Subject: load file
Hi,
I have a a text
Jim,
Saturday, April 13, 2002, 2:00:55 AM, you wrote:
JP Is it possible to load a file from a remote host as data type blob? This
JP needs to be done from within the C API.
Only using MySQL - no, with other programs/languages yes ...
--
For technical support contracts, goto