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.

Re install innodb

Discussion in 'Database Discussions' 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. cPTerrance

    cPTerrance *nix Technical Analyst II / Migrations Specialist
    Staff Member

    Joined:
    Jul 9, 2015
    Messages:
    72
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Twitter:
    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