The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Max allowed packet in MySQL

Discussion in 'Database Discussions' started by ruuz, May 6, 2010.

  1. ruuz

    ruuz Member

    Joined:
    Aug 2, 2009
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I am having bit issues in MySQL with max_allowed_packet variable.

    The scenario is like we recently changed servers.

    The old server was MySQL 4.x and the new one has MySQL 5.x

    I checked and compared variables and stuff.

    The script is going crazy because it is only able to fetch first 1MB of BLOB data from a table cell.

    I fixed it in past on old server by setting the variable in my.cnf

    This new server I already did that in etc/my.cnf

    The phpMyAdmin shows it is now set 500 MB [Just did it 500 for sake of it]

    But still my script is not working as it is not able to get that BLOB value of 1.28 MB and is just getting 1MB :(

    Any help or opinions would be appreciated as I am running out of leads.

    Thanks.
     
Loading...

Share This Page