mysql timeout or file to large?

[crunchie]

In my app I have a form with binary upload. I upload it to a temp directory on the server where I then insert it directly into the mysql db as a binary.

This all works fine until I try and upload a file of 2meg +
I thought it was the max_file_size but that is set to 5 meg. When I upload the binary via phpMyAdmin I get a timeout error.

phpMyAdmin reports that each binary can handle upto 51meg.

Any light that someone could shed on this would be most appreciated. I have a client asking for 4meg uploads!

Many thanks

crunchie

[bubblenut]

[man]set_time_limit[/man] can be used to increase the maximum execution time limit on a page by page basis.

[crunchie]

Thanks for the reply. Unfortunately the function you suggest seems to only work with a constant input which is a shame...! A Binary stream is not seen as continuous input. This has set me in the right direction and I feel that the problem lies in the ini with the max_execution_time directive. It is only set to 30 on our server so I am begging the admin to set it to 60 to see if that helps.

Many thanks!

crunchie

[bubblenut]

so set the time limit to 0 (no time limit) it's all there in the docs ... if you'd bothered to read them :rolleyes:

[crunchie]

Already tried it. No joy. Have also had the max_execution_time set to 60... Still doesnt work cry

[bubblenut]

Oh, are you getting any error displayed? If you are please copy and paste the exact error (obfuscating any paths if need be) up here please?

[crunchie]

Hey bubblenut... I have realised why now... doh! The admin had kindly taken max_file_size to 5m but left the upload_max_filesize to 2m

Heehehe

Dave

[bubblenut]

Ahh, and the moral of this story is ...

never feed the admins, they're in cages for a reason!

[crunchie]

Ahahahaha,

Well we got there in the end. Many thanks for all your advice.

crunchie