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]
