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.

Problem after switching back to MySQL from MariaDB

Discussion in 'General Discussion' started by jazz1611, Jul 17, 2013.

  1. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hi,

    I have problem with other server when replace from MariaDB to MySQL. I trying import database .sql on phpmyadmin and get error:

    A mistake!
    Bad request.
    Got error -1 from storage engine (256)

    Help me resolved it. Please.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I moved this post into it's own thread because it's a different issue than the original thread you posted it to.

    Please check the MySQL error log (/var/lib/mysql/$hostname.err to see if there is any output when this error message appears. It's possible you have some custom entries in your /etc/my.cnf file that are preventing the upload of the database.

    Thank you.
     
  3. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Current my.cnf on server

    I deleted error before and restart mysql again and see error below:

     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The following variable in your /etc/my.cnf file is not designed to be a permanent entry:

    Code:
    innodb_force_recovery=6
    You will need to remove this line, restart MySQL, and see if there are any additional errors in your MySQL error log.

    Thank you.
     
  5. jazz1611

    jazz1611 Well-Known Member

    Joined:
    Jun 5, 2012
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I removed and restarting it failed. I checked error log see:

    Can i open ticket for us resolved it? Your Request id is: 4296617.
     
    #5 jazz1611, Jul 17, 2013
    Last edited: Jul 17, 2013
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The error message indicates that InnoDB is still corrupted. Database recovery falls outside our scope of support, so a support ticket may not be helpful in this case. You may want to consult with a qualified system administrator if you are unable to repair InnoDB using traditional methods.

    Thank you.
     
Loading...

Share This Page