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.

configuring mysql

Discussion in 'General Discussion' started by scotch33, Feb 16, 2009.

  1. scotch33

    scotch33 Member

    Joined:
    Nov 20, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    I am having problems with a particular site - documents are loaded into the databasec rather than as files (its a file repository).

    At the moment, if users try to upload more than a meg the system throws its toys.

    I have researched and believe the problem to be max_allowed_packet in mysql and thus need to edit this in the config. Is there a way to edit the mysql config and change this from WHM?

    If there is, where is it?
     
  2. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    447
    Likes Received:
    4
    Trophy Points:
    18
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    I believe WHM does not have any feature to tweak mysql conf. You can do it from shell. Here is the syntax.

    root@server [~]# cat /etc/my.cnf
    [mysqld]
    set-variable = max_allowed_packet=xyzM

    xyz is any numeric value you want to set for this variable. Do not forget to restart mysql service after making this change.
     
Loading...

Share This Page