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 < daniele....@googlemail.com> wrote: > Hello, > 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. > > Thanks! > > Dan > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.