yuminanako

Member
Jul 12, 2009
11
0
51
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)
 
Last edited:

jestep

Well-Known Member
Dec 18, 2006
49
1
158
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