Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How to edit the my.cnf

Discussion in 'Database Discussion' started by jyhqp, Apr 21, 2013.

  1. jyhqp

    jyhqp Registered

    Joined:
    Apr 21, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Due to the default value of variable max_allowed_packet is 1M,I tried to import SQL files to my database but failed. It seems it is read-only in current version. I searched the solution in google and people said I must update it in my.ini.Can anyone tell me how to do this? As detailedly as possible,I am a layman to Linux. Thank you very much!
     
    #1 jyhqp, Apr 21, 2013
  2. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    1. Login to server via ssh (Use a client like putty if you are on a windows machine)

    Putty Download

    Steps to Login using Putty

    2. Backup the existing my.cnf file using the following command.

    3. Now edit the Config file and modify it according to your requirement.

    Search for max_allowed_packet in the above file.

    Edit the required value. Something higher like 16M or 32M.

    Save and quit. (To save and quit using vi editor, press [Esc] key and then : (the colon). For example, to exit from vi saving changes, press [Esc], : (colon) and type wq )

    4. Restart MySQL using the following command.

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 arunsv84, Apr 22, 2013
  3. jyhqp

    jyhqp Registered

    Joined:
    Apr 21, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi arunsv84 , I done what you said,but could not see the max_allowed_packet. As follow:

    1.jpg 2.jpg

    - - - Updated - - -

    Can anyone help me?
     
    #3 jyhqp, Apr 22, 2013
  4. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Yes. I have checked your screenshot and its not set on your my.cnf. If you wish to set some particular value just set it as mentioned before and restart MySQL.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 arunsv84, Apr 22, 2013
  5. wipes

    wipes Registered

    Joined:
    Sep 13, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi I have one question for you. I see how to do a back up for the my.cnf file, but what is the command to restore the my.cnf file if I need to. Thanks you in advance.
     
    #5 wipes, Sep 13, 2013
  6. Sys Admin

    Sys Admin Well-Known Member

    Joined:
    Apr 29, 2007
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    Root Administrator
    You can just cp the backed up file back to it's original place using the below command then restart the mysql server.

    cp -af /etc/my.cnf.bakup /etc/my.cnf
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 Sys Admin, Sep 14, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - edit
  1. BrettK

    Edit valiases, not showing up in cPanel

    BrettK, Oct 15, 2018 at 8:45 PM, in forum: E-mail Discussion
    Replies:
    2
    Views:
    38
    cPanelLauren
    Oct 17, 2018 at 12:03 PM
  2. veepee

    Editing a DocumentRoot problem

    veepee, Oct 14, 2018 at 11:14 AM, in forum: General Discussion
    Replies:
    2
    Views:
    172
    cPanelLauren
    Oct 17, 2018 at 9:32 AM
  3. Tamer Youssef

    Edit user's email white-list?

    Tamer Youssef, Oct 13, 2018 at 5:13 AM, in forum: E-mail Discussion
    Replies:
    1
    Views:
    44
    cPanelLauren
    Oct 16, 2018 at 1:00 PM
  4. 1Walter2

    MultiPHP INI Editor Server Setting Not Working

    1Walter2, Sep 29, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    89
    cPanelLauren
    Oct 4, 2018
  5. OBorgqvist

    MultiPHP INI Editor Errors occurred while retrieving the PHP INI locations.

    OBorgqvist, Sep 22, 2018, in forum: EasyApache
    Replies:
    6
    Views:
    181
    SushiCatX
    Oct 10, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice