aboallam Posted April 16, 2008 Share Posted April 16, 2008 i have stored an image with 2m size into database and when i try to extract it, the browser did not appeare any thing but when i try to extract small image it appeare, what i can do now Link to comment https://forums.phpfreaks.com/topic/101374-extracting-large-image-from-mysql/ Share on other sites More sharing options...
fenway Posted April 16, 2008 Share Posted April 16, 2008 There's a max packet size from mysql that may be responisible.. as well as a php timeout. Link to comment https://forums.phpfreaks.com/topic/101374-extracting-large-image-from-mysql/#findComment-518516 Share on other sites More sharing options...
PFMaBiSmAd Posted April 16, 2008 Share Posted April 16, 2008 Another reason to not store files in a database Databases are for storing data that you need to manipulate, sort, compare... Databases are not file storage engines (but file systems are) and in fact, since databases are stored in files in the file system, storing a file in a database is just putting one file inside of another. This just adds overhead and slows everything down. Link to comment https://forums.phpfreaks.com/topic/101374-extracting-large-image-from-mysql/#findComment-518524 Share on other sites More sharing options...
aboallam Posted April 17, 2008 Author Share Posted April 17, 2008 iam sorry for that but that is what happend with me . now i can store large image in mysql database such as 7MB image ,but when i try to extract it, it dont appeare to me but small image appeare and i changed the max_allowed_packet to 32m in my.ini file and open mysql command line client, and write show variableslike 'max%'; it show me that max_allowed_packet =33553408 and i search in net about this problem but i did not found any thing please any one help me as fast as possible Link to comment https://forums.phpfreaks.com/topic/101374-extracting-large-image-from-mysql/#findComment-519320 Share on other sites More sharing options...
fenway Posted April 17, 2008 Share Posted April 17, 2008 That still doesn't fix the php issue... and a 7MB image? Link to comment https://forums.phpfreaks.com/topic/101374-extracting-large-image-from-mysql/#findComment-519524 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.