mysql rescue - SOS!

[pelegk2]

i had a mess and by accident over writen the the 2 of the 3 DB files with the extensions :
MYI and frm
the situation now it that i have a table with mroe then 100000 lines (which end with the file extension : MYD),but when i make for example cont() on the rows i recive 504 then 100,000!!!!
the problem is beaucse i have ovveriden files!!!
how can i fiex it so all the rows will be seen!!!
this is by the way the table structure if it help :

ordc_id int(6) unsigned NOT NULL auto_increment,
  order_num varchar(8) ,
  order_date int(11) unsigned ,
  must_date int(11) unsigned ,
  done_date int(11) unsigned ,
  client_id int(9) ,
  makat varchar(14) ,
  qnt float ,
  unit_id tinyint(3) ,
  color text ,
  user_name varchar(10) ,
  status varchar(20) ,
  basis char(1) ,
  row_id int(5) unsigned ,
  mahsan char(3) NOT NULL DEFAULT '0' ,
  makat_givun varchar(14) ,
  tsir char(3) ,
  for_who varchar(30) ,
  printCount double NOT NULL DEFAULT '0' ,
  insertTime int(11) unsigned NOT NULL DEFAULT '0' ,
  updateTime int(11) unsigned NOT NULL DEFAULT '0' ,
  PRIMARY KEY (ordc_id)

thnaks in advvance
peleg

[superwormy]

If you overwrote the actual files on disk, you're probably out of luck... but, you might try making a backup and running myisakcheck or using the SQL query REPAIR TABLE query to try to repair the table.

On a side now, if you can actually overwrite those files you probabgly have a pretty misconfigured server... and why were you overwriting those files anyway?

[pelegk2]

and there wasa mess and i did a mistake an overwrote it!
can you explain mroe in detailes how may i repair it?
thnaks in addvance
peleg

[superwormy]

Go search the MySQL manual for:
myisamcheck
REPAIR SYNTAX

You might see what results a mysqldump > file.sql gives as well.