djpic Posted November 17, 2008 Share Posted November 17, 2008 Having a bit of an issue. I am trying to make a table hold some data files (photos). I am using LONGBLOB field type to store the image. The problem is that it only allows me to add a max file size of 2MB or 2,048KiB. Is there any way I can increase this? I was told it could go higher, to 1GB? What could be the problem and why is it limiting me to 2MB? Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/ Share on other sites More sharing options...
djpic Posted November 17, 2008 Author Share Posted November 17, 2008 Ok, I tried changing the php.ini from: upload_max_filesize = 2M Changed it to: upload_max_filesize = 500M But now, it will only allow me to upload a file size of 8MB or 8,192 KiB? Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-691816 Share on other sites More sharing options...
fenway Posted November 17, 2008 Share Posted November 17, 2008 This has to do with max_alllowed_packet in the mysql server config... but no one is going to upload a GB using any type of connection. Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692168 Share on other sites More sharing options...
djpic Posted November 17, 2008 Author Share Posted November 17, 2008 Might be a GB but night have a few 25MB to 500MB files needed to be sent. Where can I change that varible? Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692170 Share on other sites More sharing options...
fenway Posted November 17, 2008 Share Posted November 17, 2008 Might be a GB but night have a few 25MB to 500MB files needed to be sent. Where can I change that varible? Seriously? Your browser is going to timeout... why not ftp them? Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692175 Share on other sites More sharing options...
djpic Posted November 17, 2008 Author Share Posted November 17, 2008 because the people uploading them don't know what FTP is or how to use it. Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692176 Share on other sites More sharing options...
PFMaBiSmAd Posted November 17, 2008 Share Posted November 17, 2008 http://us2.php.net/manual/en/ini.core.php#ini.post-max-size Databases are for data that you want to efficiently search, order, and otherwise manipulate. They are not file storage engines. Use a file system to store files in, that is what file systems were designed to do efficiently. Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692253 Share on other sites More sharing options...
djpic Posted November 17, 2008 Author Share Posted November 17, 2008 ya, it was just a thought. I will store the file as a file instead, a little more difficult but ok. Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692312 Share on other sites More sharing options...
corbin Posted November 17, 2008 Share Posted November 17, 2008 I think it's easier to store it as a file, but that's just me. Quote Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692340 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.