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!

restore default my.cnf

Discussion in 'Database Discussion' started by rebornishard, Nov 29, 2013.

  1. rebornishard

    rebornishard Member

    Joined:
    Oct 30, 2012
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello all, i edited my.cnf but didn't backup first.
    Can i restore my my.cnf into it's original state / default
    thank you
     
  2. ravi9

    ravi9 Well-Known Member

    Joined:
    Oct 31, 2013
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    India
    cPanel Access Level:
    Website Owner
    Yes, you can.

    I think default settings is:
    Code:
    [mysqld]
    innodb_file_per_table=1
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    You can manually edit the /etc/my.cnf file and modify it to it's default state. However, assuming you need the previous copy and not the default copy, this file is not backed up by default. You can check to see if you have enabled the "Backup System Files" option under "Backup Configuration" to see if the file was backed up during your backup generations.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice