This is the article for you: http://php.dreamwerx.net/forums/viewtopic.php?t=6
Shows how to store large files in database... I've currently got gigs and gigs of files in mysql using this method.. On Tue, 2 Dec 2003, Jim Kutter wrote: > Hi folks. > > I'm storing files in a BLOB table for a number of reasons for my web > app, and I'm trying to break up uploads so I insert smaller chunks (my > app imposes restrictions on memory usage, so reading the whole file at > once and doing an insert doesn't work). > > What I do is insert the record, then call a series of UPDATE queries on > the record concating the new chunk with the existing blob column. > > The problem I'm having is that the size of the blob column is WAY off > for larger files (2MB or so). My app reports that the entire file was > read properly, but not all of it was inserted properly into the DB. > > Any ideas on why this is happening? Any suggestions for alternatives? > Storing the files on the filesystem is not an option for me. > > Thanks > > I'm using 3.23.36 (linux RedHat) with MyISAM tables. > > -jim kutter > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
