MySQL Error
Message: MySQL Query Error
SQL: SELECT COUNT(*) FROM uchome_feed WHERE 1 LIMIT 1
Error: Can't open file: 'gbk_uchome_feed.MYI'. (errno: 145)
Errno.: 1016
Click here to seek help.

昨天开始就出现了的问题,忙让客服的技术人员帮解决,似乎还不如自己去解决有效。于是我现了解观察了这张并非是重要的数据库,而是装载feed的信息表,也就是就算数据全部丢失,也不会有任何问题。

找到在安装源文件目录 /data/install.sql 的一段SQL 语句, 执行后,http://9mmo.com 网站就恢复了.

CREATE TABLE uchome_feed (
  feedid mediumint(8) unsigned NOT NULL auto_increment,
  appid smallint(6) unsigned NOT NULL default '0',
  icon varchar(30) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(15) NOT NULL default '',
  dateline int(10) unsigned NOT NULL default '0',
  friend tinyint(1) NOT NULL default '0',
  hash_template varchar(32) NOT NULL default '',
  hash_data varchar(32) NOT NULL default '',
  title_template text NOT NULL,
  title_data text NOT NULL,
  body_template text NOT NULL,
  body_data text NOT NULL,
  body_general text NOT NULL,
  image_1 varchar(255) NOT NULL default '',
  image_1_link varchar(255) NOT NULL default '',
  image_2 varchar(255) NOT NULL default '',
  image_2_link varchar(255) NOT NULL default '',
  image_3 varchar(255) NOT NULL default '',
  image_3_link varchar(255) NOT NULL default '',
  image_4 varchar(255) NOT NULL default '',
  image_4_link varchar(255) NOT NULL default '',
  target_ids text NOT NULL,
  PRIMARY KEY  (feedid),
  KEY uid (uid,dateline),
  KEY friend (friend,dateline),
  KEY dateline (dateline)
) ENGINE=MyISAM;