I should also mention that it's running on the same machine, so I shouldn't be having any problems from the server.
-s
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?
-- ______________________________________________ Seth Redmond
DNA resource and Database Curator Wellcome Trust Laboratories for Molecular Parasitology Department of Biological Sciences Imperial College London SW7 2AZ
[EMAIL PROTECTED] ______________________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]