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? 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? 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. 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? 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? 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. 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. 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. 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. Link to comment https://forums.phpfreaks.com/topic/133017-mysql-blob/#findComment-692340 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.