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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment 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? Quote Link to comment 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.