显示引擎；不列出InnoDB

Question

从昨天起，我在Ubuntu上安装的InnoDB表不再工作了，我尝试使用Navicat打开它们，但是我得到了“未知表引擎'InnoDB'”错误。

当我尝试使用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)

正如您所看到的，没有列出InnoDB，有关于如何解决这个问题的建议吗？或者甚至改变一个表的引擎，而不需要旧的引擎？

查过日志后，我发现了这个；

/usr/sbin/mysqld: Can't create/write to file '/tmp/ibnGBtbE' (Errcode: 13)
101129 21:03:17  InnoDB: Error: unable to create temporary file; errno: 13
101129 21:03:17 [ERROR] Plugin 'InnoDB' init function returned error.
101129 21:03:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

知道怎么解决这个问题吗？

Answer 1

听起来好像/tmp的权限搞砸了。

chmod 1777 /tmp

然后尝试重新启动mysql

Answer 2

检查你的mysql错误日志。您可能已经对您的my.cnf文件进行了更改，因为ibdata文件大小不正确，所以innodb无法插入。