AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] Incorrect key file for table ... try to repair it (126) |
|
---|---|
Sonic1997 |
Sonic1997 发表于 2014-05-05 08:08:52
最近备份出错了,而且已经出现了半个多月但一直没意识到所以也忘记当时操作了什么
输出大致是这样的: >amh backup Y n ****** 后面的似乎没有问题,所以忽略============================================================= [LNMP/Nginx] Amysql Host - AMH 4.2 http://Amysql.com [Notice] information_schema Database backup ... mysqldump: Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */ * FROM `COLUMNS`': Incorrect key file for table '/tmp/#sql_679_0.MYI'; try to repair it (126) [Notice] FTPazty00000 Database backup ... [Notice] amh Database backup ... [Notice] ceshi Database backup ... [Notice] mydzbbs_time Database backup ... [Notice] mysql Database backup ... -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. [Notice] performance_schema Database backup ... ^C 但是因为information_schema无法备份所以整个备份失败 phpMyAdmin无法点击information_schema后会没有响应 AmySQL却能正常查看 系统信息如下: ============================================================= /tmp使用情况:[LNMP/Nginx] Amysql Host - AMH 4.2 http://Amysql.com Linux: Ubuntu 12.04.1 LTS \n \l - 64BIT UpTime: 6:02 online. Time: 2014-05-05 08:00:16 LA: 0.02, 0.09, 0.07 IP: 42.96.*.* CPU: 2.38%us, 2*CPU - Intel(R) Xeon(R) CPU E5645 @ 2.40GHz Intel(R) Xeon(R) CPU E5645 @ 2.40GHz RAM: 1095MB / 2002MB HD: 19.9GB / 101.4GB tmpfs 64M 12K 64M 1% /tmp CHECK TABLE:mysql> CHECK TABLE information_schema; 求各位高手帮忙. .
ERROR 1046 (3D000): No database selected
点赞,加油! (0分)
2014-05-05 08:08:52 1
|
amysql |
回复
2014-05-05 14:31:21 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
Sonic1997 |
回复
2014-05-06 07:03:19 3
|