Seth Redmond <[EMAIL PROTECTED]> wrote:
> sorry, should have said - I get the record created, but with a null
> value in the blob - as you would for a file larger than the
> max_allowed. but I've checked numerous times (and have gone up to
> longblob) and still can't load above around 1mb.
> I should also mention that it's running on the same machine, so I
> shouldn't be having any problems from the server.
>
>
Are you sure that max_allowed_packet is set to 16M? What is the output of SHOW
VARIABLES LIKE "max_allowed_packet"?
> On Friday, June 27, 2003, at 02:06 PM,
> [EMAIL PROTECTED] wrote:
>
>>
>> Seth Redmond <[EMAIL PROTECTED]> wrote:
>>> I've been having a few problems loading blobs via the LOAD_FILE
>>> function
>>>
>>> I've tried things along the lines of:
>>>
>>> UPDATE table SET binaryRecord=LOAD_FILE("/Users/shared/filename.mov")
>>> where refNo=1;
>>>
>>> It only seems to happen when loading something over 1-1.5mb, as I've
>>> been able to load smaller files no problem but can't do anything with
>>> files of around 4mb.
>>> I'm using mediumblob (and have tried long), max allowed packet is set
>>> at 16mb. The files are readable by all, and I have file permissions
>>
>> Did you get any error message or what?
>>
>>
>>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
