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.

Error: Unknown storage engine 'InnoDB

Discussion in 'Database Discussions' 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:
    569
    Likes Received:
    15
    Trophy Points:
    18
    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.
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    667
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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
     
Loading...

Share This Page