On Thu, Jan 08, 2004 at 02:47:51PM +0000, Richard Davies wrote:
> On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> > In article <[EMAIL PROTECTED]>,
>
> > Richard Davies <[EMAIL PROTECTED]> writes:
> > > I find at present from reasons I can't work out if the image to be stored
> > > is a jpg then there is no problem but if it is a tiff them MySQL won't
> > > store it.
>
> > > insert into charts values(5,'No
> > > comment',(LOAD_FILE("/home/richard/fred.jpg")));
>
> > > works fine.
>
> > > insert into charts values(5,'No
> > > comment',(LOAD_FILE("/home/richard/fred.tiff")));
>
> > > inserts NULL instead of the image. fred.jpg and fred.tiff both exist in
> > > the same directory.
>
> > Maybe fred.tiff is larger than max_allowed_packet?
>
> No it isn't. fred.tiff is just fred.jpg copied and renamed. Apart from the
> name the files are identical at about 400k and the max_allowed_packet is set
> in /etc/my.cnf to be 10Meg.
>
Are the file permissions identical? Especially the third set is important.
Mysqld probably runs under an account (mysql) that is not yourself or in
your group, so the file needs to be world-readable. Use 'ls -l' to show
these permissions.
Also, did the copying or renaming change the case of the filename, e.g.
because you accessed it through a Samba share?
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
