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 /image.jpg or /tmp/image.jpg. (At least in MySQL 3.23.36)
>
> I *hope* this is a bug!
>
> - fleet -
>
>
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
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
