服务器挂了。。

机房断电，重启了下服务器，网站就打不开了。一直提示下面的代码。。用tools修复，进度条到一半就一直不动了。。救命啊。。

1. MySQL Error
   
2. Message: MySQL Query Error
   
3. SQL: SELECT s.uid,s.username,s.name,s.namestatus,s.groupid,sf.birthyear,sf.birthmonth,sf.birthday FROM uchome_spacefield sf LEFT JOIN uchome_space s ON s.uid=sf.uid WHERE (sf.uid IN (2746,82,255,2527,2108,3032,6521,7012,1608,6319,3164,2352,4410,7293,1586,8619,20161,144,1174,11496,7975,4381,688,1984,4689,12226,12993,1962,387,2378,1596,3571,447,4843,1138,187,3206,232,1233,3194,1746,21063,8316,2498,14261,173,4471,2336,9679,17629,546,8106,11584,3265,1302,572,4916,13397,1305,446,112,6159,3455,987,12655,8805,780,2632,307,8486,2536,855,1931,923,5663,2729,410,8202,2593,4216,1960,5305,1578,3902,2404,636,1215,262,6024,6379,140,14317,14353,12533,8044,722,211,9552,1342,13392,2605,60,6031,5747,21631,6925,5185,5455,6563,519,16084,9358,5824,4433,14116,8381,555,4098,17779,9181,2900,15996,8187,799,22682,9681,9926,3166,2540,10732,21115,8198,9768,4242,4209,2694,15860,11325,483,11534,16778,5781,11037,10308,4001,2848,7024,3883,1400,2395,9537,87,14755,339,891,436,194,6025,6043,2761,561,17415,840,21284,19604,13939,8152,29,4572,1870,1609,17590,3662,2495,3888,1228,988,503,481,21185,13037,3119,2782,2204,7192,13581,6853,19276,7237,750,21348,7982,18081,14467,6102,6717,11825,2907,3038,1287)) AND (sf.birthmonth='3' AND sf.birthday>='10' AND sf.birthday<='20')
   
4. Error: Table 'sf' is marked as crashed and should be repaired
   
5. Errno.: 1194
   
6. Click here to seek help.

复制代码

突然断电导致uchome_spacefield 表损坏，如果用tools修复不好，且是独立主机的话，可以用这里的第二种方式myisamchk 修复工具
https://discuz.dismall.com/viewthread.php?tid=235998

突然断电导致uchome_spacefield 表损坏，如果用tools修复不好，且是独立主机的话，可以用这里的第二种方式m ...
玻璃屋女孩 发表于 2010-3-15 12:12

    终于修好了。。