Redesign. Do NOT store files in a database. The kind of database that's good
a storing files, is more commonly known as "filesystem".
On Mon, Jul 13, 2009 at 2:08 PM, Daniele Development-ML <
> I'm developing a web application that requires to store large files in a
> MySQL database. The files can range up to 2Gb.
> In my understanding the upper limit for the SQL queries (thus insert
> queries) is 1GB. I'm trying, for the time being, to upload files of sizes
> around 65MB, but I still get some errors - including the "MySQL server has
> gone away".
> I followed the discussion in other post, and I properly set all the system
> variables (max_allowed_packet_size, wait_timeout) to the maximum value, but
> the error still occurs.
> Would you suggest looking at something in particular?
> For the time being, just to try this, I'm inserting the file through the
> MySQL Query Browser - just not to add other possible sources of problems on
> top of that.
Celsius is based on water temperature.
Fahrenheit is based on alcohol temperature.
Ergo, Fahrenheit is better than Celsius. QED.