locked
Need to change packet size in MySQL RRS feed

  • Question

  • User-973319413 posted

    Hi All, 

    I am storing Microsoft Documents in MySQL tables.I am able to save documents of size lesser than 5MB.However if the document size is more than 5MB, I get an error that "max_allowed_packet" size is lesser. 

    I had googled to find the answer and i found the following way to change the packet size 

    shell> mysql --max_allowed_packet=32M 

    I dont understand what this "shell>" is about.can anyone tell me where to type this command.Is it in the windows command prompt or in the MySQL command prompt.If so how to type this command?. 

    Help is very much appreciated

    Thanks and Regards 
    Ashvin RaviShankar.V

    Friday, November 25, 2011 1:14 AM

Answers

  • User-973319413 posted

    Hi,

    I found it by myself.

    Select the following file "C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

    and add the text 

    # sets max_packet to 500 MB 
    max_allowed_packet=500M
    
    group_concat_max_len=99999

    The packet size can be altered as per your wish.I had specified 500MB but you change it as well.

    Thanks

    Ashvin

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 25, 2011 2:10 AM