upload large files to longblob

[darrenm]

I have a project where I need to store large files within mysql.

I'm aware it's not the most efficient way to do things, but due to security and hosting issues, I need to in this case.

I have a database structure and scripts functioning correctly for uploading and downloading the files (using longblob column for data and varchar for storing content type), but am having problems uploading files of over about 500k. I'm getting the mysql error "MySQL server has gone away". My phi.ini settings allow uploads of 50Mb.

Any ideas? thanks.

[Roger_Ramjet]

Have a look at the max_execution_time and max_input_time parameters in your phpinfo(). I run into all kinds of problems with my host ISP having set unrealistic values in php. (I'm looking to change isp just as soon as I can find one who does not do the same. Not as easy as it sounds as there are all sorts of other considerations as well)

[darrenm]

No it's not that. The script completes it's execution because it's reaching my error display.

thanks though.

[xblue]

darrenm,

at least I can confirm that I've experienced the same behaviour in the same situation.

sorry, not any advice though, I was luckily able to redesign the application to store the files in the filesystem outside the web root to get around the problem (and it seems to be much more performant as well).