VPS侦探论坛

标题: 军哥，麻烦看下，看看是什么问题， [打印本页]

作者: yang05130 时间: 2012-5-16 19:49
标题: 军哥，麻烦看下，看看是什么问题，
120516 17:49:28 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:36 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:37 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it
120516 17:49:37 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table '/tmp/#sql_5eaf_0.MYI'; try to repair it

lnmpa启动得起来，但就是网站访问不了

作者: licess 时间: 2012-5-16 20:24
mysql -u root -p 按提示输入密码后
use database; database为你的数据库名

check table tabname;
如果出现的结果的Status是OK，则不用修复
如果有Error，则 repair table tabname;
tabname为表名

作者: yang05130 时间: 2012-5-16 20:39
标题: 回复 2# 的帖子
检测完了，修复了几个表，但是网站还是无法访问，而探针与phpmyadmin却可以

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)