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.

Can user change "max_allowed_packet" of mySQL ??

Discussion in 'General Discussion' started by taotoon, Mar 7, 2005.

  1. taotoon

    taotoon Well-Known Member

    Joined:
    Nov 14, 2004
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    I have vBulletin installed but it can't upload file more than 1Mb.
    Because default max_allowed_packet = 1M

    I already setup php:

    upload_max_filesize = 50M
    post_max_size = 51M
    memory_limit = 55M



    Can user change "max_allowed_packet" of mySQL ?
     
    #1 taotoon, Mar 7, 2005
    Last edited: Jun 26, 2009
  2. demomen

    demomen Well-Known Member

    Joined:
    Sep 25, 2004
    Messages:
    111
    Likes Received:
    0
    Trophy Points:
    16
    I think it needs to be changed on the server main config... I tried this on an older version of PHP, and it worked but it doesn't on the new ones

    mysqldump --max_allowed_packet=16M --opt -utest -p -hlocalhost databasename > backup.sql
     
Loading...

Share This Page