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.

MySQL 5.1.40 InnoDB

Discussion in 'General Discussion' started by yuminanako, Dec 18, 2009.

  1. yuminanako

    yuminanako Member

    Joined:
    Jul 12, 2009
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Linux version: CentOS release 5.4 (final)
    cPanel version: cPanel 11.25.0-E42048 - WHM 11.25.0 - X 3.9
    MySQL version: 5.1.40

    Seems like MySQL 5.1.40 lacks InnoDB. I just noticed after running /script/cpbackup and looking at the log files noticing

    Code:
    Grabbing mysql dbs........carpetc1_wrdp17 carpetc1_wrdp11 carpetc1_wrdp5 carpetc1_wrdp4 carpetc1_wrdp14 carpetc1_wrdp16 carpetc1_wrdp15 carpetc1_wrdp18 carpetc1_wrdp1 .....carpetc1_wrdp9 carpetc1_wrdp2 carpetc1_wrdp10 ..........carpetc1_wrdp7 carpetc1_wrdp12 carpetc1_wrdp3 carpetc1_wrdp19 carpetc1_wrdp6 carpetc1_wrdp8 carpetc1_wrdp13 horde.turba_objects horde.horde_prefs horde.kronolith_events horde.kronolith_storage horde.mnemo_memos horde.nag_tasks ERROR 1286 (42000) at line 1: Unknown table engine 'InnoDB'
    ...Done
    
    I also looked through /etc/my.cnf and there was no instance of skip-innodb so InnoDB should be enabled somewhat. I also got some output from mysql.
    Heres the output from mysql

    Code:
    mysql> show variables like 'have_innodb';
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | have_innodb   | NO    |
    +---------------+-------+
    1 row in set (0.00 sec)
    Code:
    mysql> show engines;
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
    | MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
    | BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
    | CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
    | MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
    | FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
    | ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    7 rows in set (0.00 sec)
     
    #1 yuminanako, Dec 18, 2009
    Last edited: Dec 18, 2009
  2. jestep

    jestep Active Member

    Joined:
    Dec 18, 2006
    Messages:
    41
    Likes Received:
    0
    Trophy Points:
    6
    In my experience this occurs when there was a problem with the Innodb files.

    Watch your mysql error log when you restart the mysql server. Most likely you will find some error.

    Log file is normally located at /var/lib/mysql/servername.err
     
Loading...

Share This Page