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.

Mysql Fail - InnoDB corruption

Discussion in 'Database Discussions' started by Alaa M, Mar 12, 2016.

  1. Alaa M

    Alaa M Member

    Joined:
    Dec 13, 2015
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Morocco, Rabat
    cPanel Access Level:
    Root Administrator
    Hi

    We have tried to change the mysql path to /Home to liberate space in the first partition which caused a stop mysql,
    There is any System Administrator Can help me to solve this problem?

    I Contacted Cpanel tea they gave me this information :

    I think the origin of the problem comes from the removal of one database by mistake.

    please if there is someone can help me, i can pay this servie.

    Thank you
     
  2. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    In /etc/my.cnf try to add below lines and restart the mysql service to recover innodb engine

    innodb_force_recovery = 1

    You can raise the number from 1 to 6 step by step untill mysql starts successfully.
     
Loading...

Share This Page