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 permission.
I'm basically out of ideas...
-s
-- ______________________________________________ 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]
