Ive got an SQL statment which keeps failing saying Blob cannot be null, but it isnt!!!
I belive the error is when the file size is too big, and it then just fails.
Is there another command or a way around increasing the maxFile limit of load_file?
The command Im currently using is:-
INSERT INTO `emailaudit_2010_01`.`email` (`priID`, `Blob`)VALUES ('bd9100c8-3da2-11df-9f1e-7aa7d63dacaa', load_file('d:\\msg.msg'))
If I put a smaller file in place of d:\msg.msg the command works great, so I think its definatly to do with size.