For an PHP example of how to import data getting around
max_packet_size, performance, etc. issues.. Be sure to read this
article.
Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html
Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6
--
MySQL General Mailing List
For list
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
hi ,
I have crerated a mysql database to store images , mp3 , video files..etc. In
my first stage i stored images as jpg , gif .
But when i try to store little but huge gif files it wont store . I used the
script as follows to upload images,
html
head
titleUpload File To MySQL
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you
thanx for the reply , usually , i uploading jpg and gif files into mysql
database , there is no any issue. we can display them correctly.
when i try to upload such huge mp3 files and some .jar files into the databse ,
i used mysqlcc GUI and SQLYOG GUI , from those interfaces also giving
AS JIGAL SAID :
make sure you are not creating an INSERT statement bigger than the
max_allowed_packet setting for both your destination server and your
client library (whichever ones you are using). If you attempt to create a
packet that is too large, the server will _ignore_ it. Because the
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for
that and not MySQL but there are a lot of advantages to it - access
control, change control