Table is marked as crashed and repair failed!

[Abdulrahman Masrani]

hello,

I have a problem in a table in my database, and here's its structure. it contains about 4000 records.

CREATE TABLE `t_node_revisions` (
 `nid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL,
  `uid` int(11) NOT NULL default '0',
  `title` varchar(128) NOT NULL default '',
  `body` longtext NOT NULL,
  `teaser` longtext NOT NULL,
  `log` longtext NOT NULL,
 `timestamp` int(11) NOT NULL default '0',
  `format` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

the problem

mysql>ANALYZE TABLE `t_node_revisions`;

Quote

d60476544.t_node_revisions analyze error Table './d60476544/t_node_revisions' is marked as crashed and last (automatic?) repair failed

This table actually crashed while I was backing up the table from a ssh client.

I tried desperately to repair it, but unfortunately I failed.

here's what I tried.

mysql> REPAIR TABLE `t_node_revisions` USE_FRM;

the error msg:

Quote

d60476544.t_node_revisions repair info Wrong bytesec: 217-130-217 at 15946488; Skipped
d60476544.t_node_revisions repair info Found block that points outside data file at 15946604
d60476544.t_node_revisions repair error Not enough memory for blob at 15946608 (need 182026713)
d60476544.t_node_revisions repair info Wrong bytesec: 217-130-217 at 15946488; Skipped
d60476544.t_node_revisions repair info Found block that points outside data file at 15946604
d60476544.t_node_revisions repair error Not enough memory for blob at 15946608 (need 182026713)
d60476544.t_node_revisions repair status Operation failed

I tried mysqlchk in the ssh client to repair the table.

mysqlcheck -r -u username -ppassword d60476544 t_node_revisions

the error msg:

Quote

d60476544.t_node_revisions
info : Wrong bytesec: 217-130-217 at 15946488; Skipped
info : Wrong bytesec: 217-130-217 at 15946488; Skipped
info : Found block that points outside data file at 15946604
error : Not enough memory for blob at 15946608 (need 182026713)
status : Operation failed

I can't use myisamchk cause it's not allowed by the server.

I can't truncate or drop the table cause it contains almost everything in my site.

I am using drupal as CMS.


I really appreciate any suggestion. Thanks for your help.