Size limit on blob files ??

AlienOne

I have big image file that I,m trying to upload but mysql wont store it but if i do the image smaller it will ?? what do i do ?? is there a limit i can change ??

Cheeres, Peter Ekberg

toplay

Well, it depends on which blob column type you used. Whether it's TINYBLOB, BLOB, MEDIUMBLOB, or LONGBLOB. See:

http://dev.mysql.com/doc/mysql/en/storage-requirements.html#id3132635

If something is too big to fit in one row, then the project/application is usually designed to handle this by splitting the data across multiple rows.

FYI:
A class for uploading/downloading files saved in MySQL. It stores 16K blocks per row:
http://www.phpclasses.org/browse/package/1582.html

Storing Images in a Database tutorial:
http://codewalkers.com/tutorials/35/1.html

Writing A File Upload Class tutorial:
http://www.phpfreaks.com/tutorials/85/0.php

🙂

AlienOne

I,m using LONGBLOB !
what is the filesize limit in mb ???

do any one know if there is another db that can store lage blobls ?? 0-20 Mb ??

AlienOne

were do i set this in osx
That sets the packet size to 32MB.

The server's default max_allowed_packet value is 1MB. You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). For example, to set the variable to 16MB, start the server like this: