问题描述
所以似乎从今天无处，我的wordpress网站下来，我跟踪它与mysql的问题。 Mysql不会在服务器上启动，因为它仍然失败。
So seemingly out of nowhere tonight, my wordpress site went down and I've traced it to problems with mysql. Mysql won't start on the server because it keeps failing.
这是我从日志中获得：
140226 08:54:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140226 08:58:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140226 8:58:20 [Note] Plugin 'FEDERATED' is disabled.
140226 8:58:20 InnoDB: The InnoDB memory heap is disabled
140226 8:58:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140226 8:58:20 InnoDB: Compressed tables use zlib 1.2.3
140226 8:58:20 InnoDB: Using Linux native AIO
/usr/libexec/mysqld: Can't create/write to file '/dev/shm/mysql/ibOqUOjF' (Errcode: 2)
140226 8:58:20 InnoDB: Error: unable to create temporary file; errno: 2
140226 8:58:20 [ERROR] Plugin 'InnoDB' init function returned error.
140226 8:58:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140226 8:58:20 [ERROR] Unknown/unsupported storage engine: InnoDB
140226 8:58:20 [ERROR] Aborting
我试过Googling并在这里看Stack Overflow，但我似乎找不到很多解决方案，除了删除ipdata1和日志文件， ，不应该使用存储的数据，因为它会弄乱我的表。
I've tried Googling and looking here on Stack Overflow, but I can't seem to find many solutions except to delete the ipdata1 and log files which, as I've read, shouldn't be done with stored data because it would mess up my tables.
这是一个NGINX CentOS 6服务器。
This is on an NGINX CentOS 6 server.
有什么想法吗？感谢您的帮助！
Any ideas? I appreciate the help!
推荐答案
AFAIK系统错误：2 =没有这样的文件或目录。
AFAIK System error: 2 = No such file or directory.
检查目录是否存在，mysql是否有写入权限，以及磁盘上是否有足够的空间。
Check that the directory exist, that mysql has permission to write to it and that there enough space left on the disk.
这篇关于Mysql服务不会启动，InnoDB init函数错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！