How to set maximum value of a blob type in mysql [Resolved]

Posted by Jerome under VB.NET on 4/23/2012 | Points: 10 | Views : 29877 | Status : [Member] | Replies : 13

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I want to attach files to a blob field in mysql,but the problem is I can't attach images more than 1 mb in size.How could I solve my problem?Need Help!

Thanks

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bugwee on: 4/24/2012 [Member] Starter | Points: 50

0	the max allowed packet variable in your sql server exceeds. try to run : set max_allowed_packet = 500M now restart the MySQl service and you are done Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bugwee on: 4/24/2012 [Member] Starter | Points: 50

0	you can also change directly the packet size via Mysql Administrator... locate and change the max_allowed_packet, under Startup Variables Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/23/2012 [Member] Starter | Points: 25

0	Hi Singaravel M, I already used LongBlob dataype but it gets error when I try to save big binary data.Do you have other idea instead? Jerome Thanks Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/23/2012 [Member] Starter | Points: 25

0	data loo long for coulum pic,which my field name... Cheers, Jerome Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/23/2012 [Member] Starter | Points: 25

0	What if image size exceeds long blob max length.. Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/23/2012 [Member] Starter | Points: 25

0	image size is 5mb Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/24/2012 [Member] Starter | Points: 25

0	where did I put this code? Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bugwee on: 4/24/2012 [Member] Starter | Points: 25

0	run it on the mysql query browser or in mysql workbench... Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/24/2012 [Member] Starter | Points: 25

0	what do you by 500M?megabyte? Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bugwee on: 4/24/2012 [Member] Starter | Points: 25

0	Yes right. M = megabyte. by default the max allowed packet size = 1M. if you want to insert files greater than 1M then you will got a max_allowed_packet error. If you want to insert 5mb files or lesser then set the max allowed packet to 5M. Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/24/2012 [Member] Starter | Points: 25

0	I could not find max_allowed_packet under startup variable.I also run the code in mysql query browser and it gets error."Incorrect argument type to variable 'max_allowed_packet' " Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bugwee on: 4/24/2012 [Member] Starter | Points: 25

0	Did you find the Startup variable or Startup parameter on the mysql Admistrator? i think, if you click on that there are tabs displayed like General parameters, my isam parameters, innodb parameters, etc.... find the the packet size in any of the tabs... i think you can see there like default value = 1M. Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jerome on: 4/24/2012 [Member] Starter | Points: 25

0	where would I found my.cnf file? Jerome, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts