Re: upload images / mp3 more Than 1 MB capacity ---- please help
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.
upload images / mp3 more Than 1 MB capacity ---- please help
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, Upload File To MySQL Database File $fileName uploaded"; } ?> 56Kb , 75 Kb files are accept to store , but more that 1 MB we cant upload. It wont give any error messages . But that particular data wont displayed. so , this is a big problem for me . i couldnt sorted out yet . I used mysqlcc and sqlYOG as well to upload images ( contents ). in like this situations how can we work with mp3 and such huge files please . help me very very urgent Thanx in advance, Kane. - Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
please help .........very urgent
hi , I wanted to check the following condition and if it is success i wanted to display a massage.I tried as follows. but no luck. nothing displayed. $dbQuery = results; $result = mysql_query($dbQuery) or die("Couldn't get file list"); if (!isset($result)) {echo "NULL";} //if (mysql_result($result == 0))( //echo "sorry"; ?> please , tell me how can i do this ? Thanx Kane. __ Click here to donate to the Hurricane Katrina relief effort. http://store.yahoo.com/redcross-donate3/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
BLOB in mysql ----- performance issue.
hi Friends, I have a WAP portal which is running based on mysql database. That's meant that contents has been stored in the data base. wallpapers , themes, ringtones, games ...etc data type as BLOB. upto now now problems with the content retrieving. WAP site hosted in REDHAT Linux BOX. I will leave my question by point form , 1. http://www.zend.com/zend/trick/tricks-sept-2001.php according to info of this link , it says there is performance issue when using BLOB for data storing and retriving in mysql and he has recomended some statndard file sharing / accessing methods to use . for instance samba or NFS - in linux. is this happening in mysql ? does it has a solution in mysql ? what could be the best way to use mysql to store / retrive my contents via the wap site ? I'm using mysql bcause , keeping data in a database is very easy to do a site search , rather than keeping contents in folders . 2. i have kept two databases in my mysql servers . for example abc , xyz. for the database abc , we are doing the content uploads. xyz for content downloads. in abc .there are more fields . a,b,c,d,e,f,g,.s in xyz there are more and different fields .aa,bb.cc,dd,eess so i wanted to transfer that contents get stored in abc to xyz. not all fields . few from abc to xyz. how it could be done ? can somebody help me ? Thanx in advance, Kane. - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.