Im trying to load data (a file) into a TBlobfield/longblob. It works with small files like .gif with a size of about 30k. When i try to load a EXE file size of 2.5 mb file i get an error:
Lost connection to mysql during query...Socket error on write..wsa get last error return 10054($2746)
Code:
with q_file do begin
execute;
open;
blob:=FieldbyName('theFile') as TBlobField;
Edit;
blob.LoadFromFile(od_upload.FileName);
Post;
Close;
Problem with TblobField.Loadfromfile
To solve the problem try to increase the values of the following variables in the my.ini file, like this:
net_read_timeout = 31536000
net_write_timeout = 31536000
max_allowed_packet = 16M
Also try to increase the size of memory buffers using MySQL server variables like key_buffer_size or innodb_buffer_pool_size. For more information about these variables read MySQL Reference Manual.
net_read_timeout = 31536000
net_write_timeout = 31536000
max_allowed_packet = 16M
Also try to increase the size of memory buffers using MySQL server variables like key_buffer_size or innodb_buffer_pool_size. For more information about these variables read MySQL Reference Manual.