Jump to content

Recommended Posts

question 1:

there's a limit on how much you can upload and insert into a blob field in phpMyAdmin: 8192 kb, this is certainly not the blob limit, a quick search on google says it's a process stack size limit. 

what is this 8192 kb limit?  is it simply the limit on file size that can be uploaded into phpMyAdmin? what's the reason behind it?

 

question 2:

another related issue is  whenever I tries to insert a big file(for example, >1MB) into a longblob field using mysql_query, mysql dies and says "MySQL server has gone away"), smaller files are ok.. what's up with that?

thanks

 

Link to comment
https://forums.phpfreaks.com/topic/66580-blob-field-limitation/
Share on other sites

Thanks!

for 2) I found out that there's a bug in my mysql community server version 5.02

http://bugs.mysql.com/bug.php?id=14955

so I'm stuck with 1MB max file insert blob unless I upgrade mysql server.... which I am hesitant to do.

so much for trying to store files in database...

Link to comment
https://forums.phpfreaks.com/topic/66580-blob-field-limitation/#findComment-333527
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.