topcoder1 Posted August 24, 2007 Share Posted August 24, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/66580-blob-field-limitation/ Share on other sites More sharing options...
MadTechie Posted August 24, 2007 Share Posted August 24, 2007 1. to stop people trying to overload the system with too much data in one go. 2. the server timed out and closed the connection to the SQL server. Quote Link to comment https://forums.phpfreaks.com/topic/66580-blob-field-limitation/#findComment-333515 Share on other sites More sharing options...
topcoder1 Posted August 24, 2007 Author Share Posted August 24, 2007 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... Quote Link to comment https://forums.phpfreaks.com/topic/66580-blob-field-limitation/#findComment-333527 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.