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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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.
