Size Limits On Uploaded Photos

[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