Size Limits On Uploaded Photos

[Tarheel]

I am using SQLyog Enterprise – MySQL GUI v5.16 to access and manipulate a MySQL 4.1 database. When I import a large photo (~600K:cool: to a BLOB field in my database and save the changes, the database appears to accept it. I can even view the entire photo. However, when I refresh the database, the field shows only 63KB and I can view only a small/top portion of the photo. The same is true when I use PHP pages to view the database records.

I have checked with my host provider and they have indicated that I am “set to unlimited on the server” so the database should accept the larger photos.

Is the problem with SQLyog and if so, what can be done to allow me to upload large files? If the problem is with the database, what changes need to be made? Thanks.

[peterlaursen]

There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

If you create a ticket I can arrange access to a database on another server (tomorrow!).

Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

Tickets: http://www.webyog.com/support/ttx.cgi

[Tarheel]

I upgraded to the 5.2 beta5 and as you predicted, it did not solve the problem.

I then changed the field from BLOB to LONGBLOB and that solved it. I just uploaded a ~600KB image file successfully. Thanks for your prompt response. I am very pleased the SQLyog program.

peterlaursen wrote on Oct 2 2006, 01:54 PM:

There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

If you create a ticket I can arrange access to a database on another server (tomorrow!).

Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

Tickets: http://www.webyog.com/support/ttx.cgi

[peterlaursen]

OK …

you can read about the max. storage size of different variable types here:

http://dev.mysql.com/doc/refman/5.0/en/sto…quirements.html

BLOB: 2^16 byte ~64 KB

MEDIUBLOB: 2^24 byte ~ 1.6 MB

LONGBLOB: 2^32 byte ~ 4 GB

Data are truncated if they are too big. However I did not notice because my image was a Interlaced TIFF image and with that resolution it displayed OK actually (there were lots of 'holes' in it but they were not visible). A .JPG on the opposite will simply be cut off!

[Author]

Posts