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 packet
(SQL statement) is too large, it is considered "malformed" and any
processing of it will be aborted.
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
http://dev.mysql.com/doc/refman/5.0/en/memory-use.html
http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Kane Wilson <gsm_color@stripped> wrote on 10/13/2005 09:25:24 AM:
> 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 troubles. contents wont stored.
> my requrement is any how keep the contents , in the mysql database,
> i have high performance machine. so then i'm not worry about
perforamnce.
>
> please , let me know how could be the way to store such files in a
> mysql databse ???
>
> please help
>
>
> Jigal van Hemert <jigal@stripped> wrote:
> 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 use that method.
>
> I do think that you exceeded the max_allowed_packet size for MySQL
> queries which has a default value of 1048576 (=1MB). You can increase
> this number (must be done in both client and server!!), but it is
> usually best to store huge files in a file system and not in a database.
>
> Kind regards, Jigal.
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
