ay, July 17, 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.
SOLUT
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 abo
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 /tm
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 MySQ
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:
[EM
[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 lo
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 load is /home/fleet/image.jpg
