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!

Error: Unknown storage engine 'InnoDB

Discussion in 'Database Discussion' started by YasIT, Jun 14, 2014.

  1. YasIT

    YasIT Active Member

    Joined:
    Jan 3, 2014
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Error in repair table MySQL Database :
    Code:
    [whmcsyas_5.tblactivitylog] Error: Unknown storage engine 'InnoDB'
    [whmcsyas_5.tblactivitylog] error: Corrupt
    [whmcsyas_5.tbladdonmodules] Error: Unknown storage engine 'InnoDB'
    [whmcsyas_5.tbladdonmodules] error: Corrupt
    
    Error in Command line ssh :

    Code:
    root@bazdid [~]# mysqladmin variables | grep have_innodb
    | have_innodb | DISABLED |
    
    
    mysql> show engines;
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine | Support | Comment | Transactions | XA | Savepoints |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | MyISAM | DEFAULT | MyISAM storage engine | NO | NO | NO |
    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
    | CSV | YES | CSV storage engine | NO | NO | NO |
    | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
    | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
    | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
    | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
    | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    8 rows in set (0.00 sec)
    
    
    mysql> show engine innodb status;
    ERROR 1286 (42000): Unknown storage engine 'innodb'
    
    
    
    MySQL 5.6
    Please help step by step to fix this problem.
     
  2. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    143
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    What do you have in your /etc/my.cnf file?

    Code:
    cat /etc/my.cnf
    
    Please paste that here.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. ravijas

    ravijas Member

    Joined:
    Jul 24, 2014
    Messages:
    13
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    hello,

    having same pro,

    # cat /etc/my.cnf
    [mysqlhotcopy]
    interactive-timeout
    log-slow-queriies="/var/lib/mysql/slow.log"
    [mysqldump]
    max_allowed_packet=4M
    quick
    [mysql]
    no-auto-rehash
    [mysqld]
    thread_cache_size=8
    max_allowed_packet=268435456
    query_cache_size=32M
    innodb_file_per_table=1
    innodb_log_file_size = 12M
    server-id=1
    table_cache=512
    sort_buffer_size=2M
    myisam_sort_buffer_size=64M
    wait_timeout=20
    thread_concurrency=8
    default-storage-engine=MyISAM
    key_buffer=384M
    max_connections=25
    max_user_connections=25
    skip-external-locking
    read_rnd_buffer_size=8M
    connect_timeout=20
    read_buffer_size=2M
    open_files_limit=50000
    innodb_buffer_pool_size=134217728
    [myisamchk]
    read_buffer=2M
    sort_buffer_size=128M
    key_buffer=128M
    write_buffer=2M
    ------------------
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

    Try copying your /etc/my.cnf file to another location to ensure it's backed up, and then use a standard empty /etc/my.cnf file to see i f that makes a difference. Ensure you restart MySQL after implementing the default /etc/my.cnf file. If the issue persists, the following thread is helpful if you need to repair InnoDB:

    Repairing InnoDB

    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