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!

Re install innodb

Discussion in 'Database Discussion' started by sweatbar, Aug 1, 2015.

  1. sweatbar

    sweatbar Registered

    Joined:
    Aug 1, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Colombo
    cPanel Access Level:
    Root Administrator
    InnoDB is not in my cpanel im using centos 6.6 as my OS .

    /etc/my.cnf doesnt have a skip innoDB notation



    > show engines;
    +--------------------+---------+----------------------------------------------------------+--------------+------+------------+
    | Engine | Support | Comment | Transactions | XA | Savepoints |
    +--------------------+---------+----------------------------------------------------------+--------------+------+------------+
    | CSV | YES | CSV storage engine | NO | NO | NO |
    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
    | MyISAM | DEFAULT | MyISAM storage engine | NO | NO | NO |
    | BLACKHOLE | YES | /dev/null storage engine (anything you wr it disappears) | NO | NO | NO |
    | MEMORY | YES | Hash based, stored in memory, useful for ary tables | NO | NO | NO |
    | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
    | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
    | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
    +--------------------+---------+----------------------------------------------------------+--------------+------+------------+


    how do i re install my sql to use innoDB?
     
  2. TerranceR

    TerranceR Well-Known Member

    Joined:
    Jul 9, 2015
    Messages:
    74
    Likes Received:
    10
    Trophy Points:
    83
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Hello,

    You may want to try restarting MySQL and then "tail -n 100 /var/lib/mysql/hostname.example.com.err" replacing hostname.example.com with your actual hostname. That will likely tell you what the issue is, if not please paste your full /etc/my.cnf
     
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